RE: Arabic / Other languages POI Excel Writing
Our community has already tested it :) http://robertdudley.wordpress.com/2010/05/07/upgrade-java-poi-for-better-excel-support-in-coldfusion-8/ Guess it's going to be safe, will report if I face any issues. Thx rgds, Pradeep Viswanathan R -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, February 29, 2012 8:56 PM To: cf-talk Subject: Re: Arabic / Other languages POI Excel Writing I used the same source with CF 8 and 9 and it works properly in CF 9. Good to hear! I guess some of the changes between poi v2.5 (CF8) and v3.5 (CF9) must have involved unicode :) Guess updating few with the new versions will solve the issue. If they are compatible with CF8, yes. (I do not know). Just keep in mind the POI jars are also used by CF8. So there is the possibility updating the jars *might* break other things. -Lei ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Arabic / Other languages POI Excel Writing
Leigh, It worked!!! Thanks :D I used the same source with CF 8 and 9 and it works properly in CF 9. Looking into the bin folder, I find few poi*.jar, Guess updating few with the new versions will solve the issue. Please let me know if you have any inputs Thx rgds, Pradeep Viswanathan R -Original Message- From: IT (Pradeep Viswanathan) Sent: Wednesday, February 29, 2012 1:19 AM To: cf-talk@houseoffusion.com Subject: RE: Arabic / Other languages POI Excel Writing I would not say it is the CFC, rather I would say it's POI or I should Unicode the data before sending it to POI. I am using CF8 , will test it out on different version and get back. Also noticed that this issue also exists if use a cfheader with excel, will post some samples in the morning Data I remember CFdumping it to the screen it was all right. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, February 29, 2012 1:14 AM To: cf-talk Subject: Re: Arabic / Other languages POI Excel Writing Are you sure it is a problem with the cfc? The first thing to check is whether your data is stored properly as unicode. If you output the characters on screen, do they display properly? I have never used cfHSSF, but all three (cfHSSF, POUtitlity and cfspreadsheet) use POI internally. So the behavior should be similar. I imagine the biggest differences would be the version you are using. CF7 includes a much older version of POI than CF9 (2.x vs 3.x). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Arabic / Other languages POI Excel Writing
I used the same source with CF 8 and 9 and it works properly in CF 9. Good to hear! I guess some of the changes between poi v2.5 (CF8) and v3.5 (CF9) must have involved unicode :) Guess updating few with the new versions will solve the issue. If they are compatible with CF8, yes. (I do not know). Just keep in mind the POI jars are also used by CF8. So there is the possibility updating the jars *might* break other things. -Lei ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Arabic / Other languages POI Excel Writing
Are you sure it is a problem with the cfc? The first thing to check is whether your data is stored properly as unicode. If you output the characters on screen, do they display properly? I have never used cfHSSF, but all three (cfHSSF, POUtitlity and cfspreadsheet) use POI internally. So the behavior should be similar. I imagine the biggest differences would be the version you are using. CF7 includes a much older version of POI than CF9 (2.x vs 3.x). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350139 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Arabic / Other languages POI Excel Writing
I would not say it is the CFC, rather I would say it's POI or I should Unicode the data before sending it to POI. I am using CF8 , will test it out on different version and get back. Also noticed that this issue also exists if use a cfheader with excel, will post some samples in the morning Data I remember CFdumping it to the screen it was all right. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, February 29, 2012 1:14 AM To: cf-talk Subject: Re: Arabic / Other languages POI Excel Writing Are you sure it is a problem with the cfc? The first thing to check is whether your data is stored properly as unicode. If you output the characters on screen, do they display properly? I have never used cfHSSF, but all three (cfHSSF, POUtitlity and cfspreadsheet) use POI internally. So the behavior should be similar. I imagine the biggest differences would be the version you are using. CF7 includes a much older version of POI than CF9 (2.x vs 3.x). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Arabic / Other languages POI Excel Writing
Are you using POI directly or through some kind of wrapper (ie cfspreadsheet, poiUtility.cfc, etcetera..)? Can you post your code? Leigh, Thanks for the response. I am using cfHSSF from http://www.1smartsolution.com/?action=downloads and i am using the function easyQuery2Excel(). In others words, not written any code for this. Which one do you recommend please ? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Arabic / Other languages POI Excel Writing
Are you using POI directly or through some kind of wrapper (ie cfspreadsheet, poiUtility.cfc, etcetera..)? Can you post your code? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm