private void addColumnValues(HSSFSheet sheet, List columns, HtmlDataTable dataTable) { for(int i=0 ; i < dataTable.getRowCount(); i++) { dataTable.setRowIndex(i); HSSFRow row = sheet.createRow( i + 1 ); for (int j=0; j < columns.size(); j++) { UIColumn column = (UIColumn) columns.get(j); addColumnValue(row, (UIComponent) column.getChildren().get(0), j); } } }
private static void generateTableContent(FacesContext facesContext, PdfPTable pdfTable, List columns, HtmlDataTable dataTable) { int numberOfColumns = columns.size(); int numberOfRows = dataTable.getRowCount(); int startFrom = 0; int endAt = numberOfRows; /* fill the table with the data. */ for (int i = startFrom; i < endAt; ++i) { dataTable.setRowIndex(i); for (int j = 0; j < numberOfColumns; ++j) { String cellValue = ""; UIColumn currentColumn = (UIColumn) columns.get(j); for (int k = 0; k < currentColumn.getChildren().size(); ++k) { if (currentColumn.getChildren().get(k) instanceof ValueHolder) { cellValue += ((ValueHolder) currentColumn.getChildren() .get(k)).getValue(); } } pdfTable.addCell(cellValue); } } }
private static void generateTableContent(FacesContext facesContext, PdfPTable pdfTable, List columns, HtmlDataTable dataTable) { int numberOfColumns = columns.size(); int numberOfRows = dataTable.getRowCount(); int startFrom = 0; int endAt = numberOfRows; /* fill the table with the data. */ for (int i = startFrom; i < endAt; ++i) { dataTable.setRowIndex(i); for (int j = 0; j < numberOfColumns; ++j) { String cellValue = ""; UIColumn currentColumn = (UIColumn) columns.get(j); for (int k = 0; k < currentColumn.getChildren().size(); ++k) { if (currentColumn.getChildren().get(k) instanceof ValueHolder) { cellValue += ((ValueHolder) currentColumn.getChildren() .get(k)).getValue(); } } pdfTable.addCell(cellValue); } } }
private static void generateTableContent(FacesContext facesContext, HSSFSheet sheet, List columns, HtmlDataTable dataTable) { int numberOfColumns = columns.size(); int numberOfRows = dataTable.getRowCount(); int startFrom = 0; int currentIndex = 1; int endAt = numberOfRows; /* fill the table with the data. */ for (int i = startFrom; i < endAt; ++i) { dataTable.setRowIndex(i); HSSFRow row = sheet.createRow(currentIndex++); for (int j = 0; j < numberOfColumns; ++j) { UIColumn column = (UIColumn) columns.get(j); String cellValue = ""; for (int k = 0; k < column.getChildren().size(); ++k) { if (column.getChildren().get(k) instanceof ValueHolder) { cellValue += ((ValueHolder) column.getChildren().get(k)) .getValue(); } } addColumnValue(row, cellValue, j); } } }
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 void generateTableContent(FacesContext facesContext, HSSFSheet sheet, List columns, HtmlDataTable dataTable) { int numberOfColumns = columns.size(); int numberOfRows = dataTable.getRowCount(); int startFrom = 0; int currentIndex = 1; int endAt = numberOfRows; /* fill the table with the data. */ for (int i = startFrom; i < endAt; ++i) { dataTable.setRowIndex(i); HSSFRow row = sheet.createRow(currentIndex++); for (int j = 0; j < numberOfColumns; ++j) { UIColumn column = (UIColumn) columns.get(j); String cellValue = ""; for (int k = 0; k < column.getChildren().size(); ++k) { if (column.getChildren().get(k) instanceof ValueHolder) { cellValue += ((ValueHolder) column.getChildren().get(k)) .getValue(); } } addColumnValue(row, cellValue, j); } } }
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 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; } }
protected void encodeHtmlDataTableChildren(FacesContext context, HtmlDataTable htmlDataTable) throws IOException { ResponseWriter writer = context.getResponseWriter(); writer.startElement(JsfConstants.TBODY_ELEM, htmlDataTable); LoopIterator rowClasses = toStyleLoopIterator(htmlDataTable .getRowClasses()); LoopIterator columnClasses = toStyleLoopIterator(htmlDataTable .getColumnClasses()); int start = htmlDataTable.getFirst(); int rows = htmlDataTable.getRows(); boolean allRow = true; if (0 < rows) { allRow = false; } htmlDataTable.setRowIndex(start); for (int rowIndex = start; ((allRow || 0 < rows) && htmlDataTable .isRowAvailable());) { encodeBodyRow(context, htmlDataTable, writer, rowClasses, columnClasses); rowIndex++; rows--; htmlDataTable.setRowIndex(rowIndex); } writer.endElement(JsfConstants.TBODY_ELEM); }
dataTable.setRowIndex(currentRowIndex);
dataTable.setRowIndex(currentRowIndex);