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
Arabic / Other languages POI Excel Writing
I have been trying to export data with Arabic characters into excel sheet using POI, but just get junk characters as below.asd #F' EF #-/ 9ED'! (FC 'D%E'1'* /(J 'DH7FJ H#1:( 'D'3*A3'1 9F 'D(7'BG 'D0G(JG HE' GJ EEJ2'*G' Google tells me that Arabic is supported by POI and I need to convert the data into Unicode. Any suggestions/examples on this please? Thanks in advance Thx rgds, Pradeep Viswanathan R DISCLAIMER: This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons. ~| 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:349956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm