Different Excel Versions
You can export to formats suitable for particular versions of Excel, such as Excel 2000, Excel 95, or an Excel Spreadsheet with no page breaks for easier data manipulation. Instantiate the ExcelGenerator with the version parameter as follows:
//Excel 2000
ExcelGenerator gen =
ExcelGenerator.createExcelGenerator(
new FileOutputStream("report.xls"),
ExcelGenerator.EXCEL2000);
//Excel 95
ExcelGenerator gen =
ExcelGenerator.createExcelGenerator(
new FileOutputStream("report.xls"),
ExcelGenerator.EXCEL95);
//Excel with no page breaks
ExcelSheetGenerator gen =
ExcelSheetGenerator.createExcelGenerator(
new FileOutputStream("report.xls"),
ExcelGenerator.EXCEL_SHEET);
| << ExcelGenerator and ExcelSheetGenerator Classes | © 1996-2013 InetSoft Technology Corporation (v11.4) | 3.8.3 Exporting to HTML Programmatically >> |