/** * Writes a XLS (Excel workbook) representation of the given list of Grids to the given OutputStream. */ public static void toXls( List<Grid> grids, OutputStream out ) throws Exception { WritableWorkbook workbook = openWorkbook( out ); for ( int i = 0; i < grids.size(); i++ ) { Grid grid = grids.get( i ); String sheetName = CodecUtils.filenameEncode( StringUtils.defaultIfEmpty( grid.getTitle(), XLS_SHEET_PREFIX + (i + 1) ) ); toXlsInternal( grid, workbook, sheetName, i ); } workbook.write(); workbook.close(); }
/** * Writes a XLS (Excel workbook) representation of the given Grid to the given OutputStream. */ public static void toXls( Grid grid, OutputStream out ) throws Exception { WritableWorkbook workbook = openWorkbook( out ); String sheetName = CodecUtils.filenameEncode( StringUtils.defaultIfEmpty( grid.getTitle(), XLS_SHEET_PREFIX + 1 ) ); toXlsInternal( grid, workbook, sheetName, 0 ); workbook.write(); workbook.close(); }
/** * Writes an XML representation of the given Grid to the given OutputStream. */ public static void toXml( Grid grid, OutputStream out ) { XMLWriter writer = XMLFactory.getXMLWriter( out ); writer.openDocument(); writer.openElement( ATTR_GRID, ATTR_TITLE, grid.getTitle(), ATTR_SUBTITLE, grid.getSubtitle(), ATTR_WIDTH, String.valueOf( grid.getWidth() ), ATTR_HEIGHT, String.valueOf( grid.getHeight() ) ); writer.openElement( ATTR_HEADERS ); for ( GridHeader header : grid.getHeaders() ) { writer.writeElement( ATTR_HEADER, null, ATTR_NAME, header.getName(), ATTR_COLUMN, header.getColumn(), ATTR_TYPE, header.getType(), ATTR_HIDDEN, String.valueOf( header.isHidden() ), ATTR_META, String.valueOf( header.isMeta() ) ); } writer.closeElement(); writer.openElement( ATTR_ROWS ); for ( List<Object> row : grid.getRows() ) { writer.openElement( ATTR_ROW ); for ( Object field : row ) { writer.writeElement( ATTR_FIELD, field != null ? String.valueOf( field ) : EMPTY ); } writer.closeElement(); } writer.closeElement(); writer.closeElement(); writer.closeDocument(); }
table.setSpacingAfter( spacing ); table.addCell( resetPaddings( getTitleCell( grid.getTitle(), grid.getVisibleWidth() ), 0, 30, 0, 0 ) );