/** * This utility method is used for generating the excel * table to the HttpServletResponse object. * @param workBook * @param response * @param fileName * @throws IOException */ public static void generateEXCEL(FacesContext facesContext, HttpServletResponse response, String fileName, HtmlDataTable dataTable) throws IOException { /* * By default if the fileName is not specified, then use the * table id. */ if (fileName == null) { fileName = dataTable.getId(); } /* generate the excel model */ HSSFWorkbook generatedExcel = ExcelExporterUtil .generateExcelTableModel(facesContext, dataTable); writeExcelToResponse(response, generatedExcel, fileName); }
/** * This utility method is used for generating the excel * table to the HttpServletResponse object. * @param workBook * @param response * @param fileName * @throws IOException */ public static void generateEXCEL(FacesContext facesContext, HttpServletResponse response, String fileName, HtmlDataTable dataTable) throws IOException { /* * By default if the fileName is not specified, then use the * table id. */ if (fileName == null) { fileName = dataTable.getId(); } /* generate the excel model */ HSSFWorkbook generatedExcel = ExcelExporterUtil .generateExcelTableModel(facesContext, dataTable); writeExcelToResponse(response, generatedExcel, fileName); }
private static HSSFWorkbook generateExcelTableModel( FacesContext facesContext, HtmlDataTable dataTable) { HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(dataTable.getId()); List columns = getColumns(dataTable); int currentRowIndex = dataTable.getRowIndex(); addColumnHeaders(sheet, columns); generateTableContent(facesContext, sheet, columns, dataTable); dataTable.setRowIndex(currentRowIndex); return workbook; } }
private HSSFWorkbook generateExcel(FacesContext facesContext, HtmlDataTable table) { HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(table.getId()); List columns = getColumns(table); int currentRowIndex = table.getRowIndex(); addColumnHeaders(sheet, columns); addColumnValues(sheet, columns, table); table.setRowIndex( currentRowIndex ); return workbook; }
private static HSSFWorkbook generateExcelTableModel( FacesContext facesContext, HtmlDataTable dataTable) { HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(dataTable.getId()); List columns = getColumns(dataTable); int currentRowIndex = dataTable.getRowIndex(); addColumnHeaders(sheet, columns); generateTableContent(facesContext, sheet, columns, dataTable); dataTable.setRowIndex(currentRowIndex); return workbook; } }
fileName = dataTable.getId();
fileName = dataTable.getId();