I know this is a common question (Googled over javaranch and other forums but couldn't get the solution) . I'm using JExcelAPI for reading the data from Excel and storing the data in CSV a sample program didn't include much of criteria .
This is my code snippet
On the display i'm getting æ±‰è¯/æ¼¢èªž set of junk values for chinese characters .
Arun Giridhar wrote:When i tried to open the .csv with Micrsoft Word . I get perfect set of chinese character but i don't see the samething open via EXCEL.I'm reading/writing a set of 15000 Records of chinese character.
That suggests that the characters are being stored correctly in the file, and that your Excel is not configured for the proper charset.
I heard that JexcelAPI going to support .xslx format. Is it true ?
Joined: Mar 22, 2005
I haven't checked lately, but I've never seen any indication that jExcelApi will handle the XML formats. It seems moribund in general. I'd expect any clues about its status to show up on its website or mailing list.