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.5) 3.8.3 Exporting to HTML Programmatically >>