I read the postings about export data to excel. I had this part done in English but when my data are in double byte, the data are not readable. Anyone has any idea? Thanks!
June, You are using what I consider a tab/comma separated file. The only thing I can think of is to make sure you set the proper encoding in the header.
Jeanne, I set the content type to utf-8 for the jsp file already, but your suggestion confirms my thought that the header causes the problem too. Will take a look at it again and may find out what was changed in the middle process. Thanks
When I do response.setContentType("text/html; charset=UTF-8") before I filter the code to export to excel, it worked for double byte language but some single byte lang. don't work such as French. My websphere server is on English machine and my applications can be viewed in different languages. Anybody knows what is missing here? Thanks!
oops copy/paste wrong line, the setting should be: response.setContentType("application/vnd.ms-excel; charset=UTF-8"); It looks like if I set utf-8, the double byte lang. work and single byte doesn't work. If I don't set uft-8, the single byte works and double byte lang. doesn't work. I don't know what is going on here. Please help. Thanks
JQ
No thanks. We have all the government we need. This tiny ad would like you to leave now:
a bit of art, as a gift, the permaculture playing cards