Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#170 Patch to Support Multi-byte Characters in Excel Export

open
nobody
Quantum (119)
5
2009-01-22
2009-01-22
apptaro
No

This is a patch to support international (multi-byte) characters in Excel export. Currently, all international characters get corrupted when exporting to Excel, because cell encoding is not properly set. This patch modifies so that cell.setEncoding(HSSFCell.ENCODING_UTF_16) is called when data contains multi-byte characters. Please see Question 13 of POI FAQ: http://poi.apache.org/faq.html

This patch also corrects line separators in Excel exports. Line separators used in Excel is LF. When data contains line separators such as CR+LF or CR and exported as is, CRs will be changed to spaces or some other characters in Excel ( http://support.microsoft.com/kb/822372/ja ) This patch converts all CR+LF and CR to LF.

Discussion