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
