全部采用UTF-8编码
Q1: eXtremeTable用POI导出为Excel时的中文解决办法
A: org.extremecomponents.table.view.xlsView.java
1)wb.setSheetName( 0, "SomeUnicodeName", HSSFWorkbook.ENCODING_UTF_16 );
2)// for cell value HSSFCell cell = row.createCell(cellnum); cell.setEncoding(HSSFCell.ENCODING_UTF_16);//unicode for eastern language
3)cell.setCellStyle((HSSFCellStyle) styles.get("textStyle")); cell.setEncoding(HSSFCell.ENCODING_UTF_16);//unicode for eastern language
Q2: eXtremeTable 用FOP导出为PDF的中文解决办法
A: Step1.在windowsXP下,生成中文字体 java org.apache.fop.fonts.apps.TTFReader C:/windows/Fonts/simhei.ttf simhei.xml java org.apache.fop.fonts.apps.TTFReader -ttcname "SimSun" C:/windows/Fonts/simsun.ttc simsun.xml
Step2.修改FOP 的 config.xml,在 中添加如下内容
Step3.拷贝上述三个文件到 应用服务器的根目录下
Step4.修改org.extremecomponents.table.filter.ExportFilter.java如下: Options options = new Options(new File("config.xml")); driver.setLogger(log); driver.setRenderer(Driver.RENDER_PDF); driver.run();
Step5.修改org.extremecomponents.table.view.PdfView.java xlsfo.append(" " + value + " "); simsun 可以为simsun或simhei 其它header and footer 类似
Step6.修改org.extremecomponents.table.view.PdfView.java sb.append(" ");