List of usage examples for org.apache.poi.hssf.usermodel HSSFRow createCell
@Override public HSSFCell createCell(int column)
From source file:com.grant.data.ItemDAO.java
public boolean getStockOutReport(ReportICatogory ric) throws FileNotFoundException, IOException { ResultSet rs = null;/*from w w w . j a v a 2 s. co m*/ Connection dbConn = null; boolean ss = false; try { dbConn = dbConnManager.connect(); Statement stmt = dbConn.createStatement(); String query = "SELECT * FROM grant_item_print WHERE d_in_date BETWEEN '" + ric.getItemIDateStart() + "' AND '" + ric.getItemInDateEnd() + "'"; System.out.println(query); rs = stmt.executeQuery(query); ///////////// HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("lawix10"); HSSFRow rowhead = sheet.createRow((short) 0); //rowhead.createCell((short) 0).setCellValue("Item ID"); rowhead.createCell((short) 1).setCellValue("i_itin_id"); rowhead.createCell((short) 2).setCellValue("v_item_name"); rowhead.createCell((short) 3).setCellValue("v_item_no"); rowhead.createCell((short) 4).setCellValue("v_ref_code"); rowhead.createCell((short) 5).setCellValue("v_descrip"); rowhead.createCell((short) 6).setCellValue("v_invo_no"); rowhead.createCell((short) 7).setCellValue("i_outwards"); rowhead.createCell((short) 8).setCellValue("v_outtype"); rowhead.createCell((short) 9).setCellValue("i_balance"); rowhead.createCell((short) 10).setCellValue("i_unit_price"); rowhead.createCell((short) 11).setCellValue("i_amount"); rowhead.createCell((short) 12).setCellValue("i_sub_total"); rowhead.createCell((short) 13).setCellValue("i_discount"); rowhead.createCell((short) 14).setCellValue("i_total"); rowhead.createCell((short) 15).setCellValue("d_in_date"); rowhead.createCell((short) 16).setCellValue("v_cus_name"); rowhead.createCell((short) 17).setCellValue("v_address"); rowhead.createCell((short) 18).setCellValue("v_payType"); rowhead.createCell((short) 19).setCellValue("v_no"); rowhead.createCell((short) 20).setCellValue("v_order_no"); int i = 1; while (rs.next()) { HSSFRow row = sheet.createRow((short) i); //row.createCell((short) 0).setCellValue(Integer.toString(rs.getInt(0))); row.createCell((short) 1).setCellValue(rs.getString(1)); row.createCell((short) 2).setCellValue(rs.getString(2)); row.createCell((short) 3).setCellValue(rs.getString(3)); row.createCell((short) 4).setCellValue(rs.getString(4)); row.createCell((short) 5).setCellValue(rs.getString(5)); row.createCell((short) 6).setCellValue(rs.getString(6)); row.createCell((short) 7).setCellValue(rs.getString(7)); row.createCell((short) 8).setCellValue(rs.getString(8)); row.createCell((short) 9).setCellValue(rs.getString(9)); row.createCell((short) 10).setCellValue(rs.getString(10)); row.createCell((short) 11).setCellValue(rs.getString(11)); row.createCell((short) 12).setCellValue(rs.getString(12)); row.createCell((short) 13).setCellValue(rs.getString(13)); row.createCell((short) 14).setCellValue(rs.getString(14)); row.createCell((short) 15).setCellValue(rs.getString(15)); row.createCell((short) 16).setCellValue(rs.getString(16)); row.createCell((short) 17).setCellValue(rs.getString(17)); row.createCell((short) 18).setCellValue(rs.getString(18)); row.createCell((short) 19).setCellValue(rs.getString(19)); row.createCell((short) 20).setCellValue(rs.getString(20)); i++; } FileDateTime fileDateTime = new FileDateTime(); FileOutputStream fileOut = new FileOutputStream(fileDateTime.getFileName("Stock_Out")); workbook.write(fileOut); fileOut.close(); ss = true; } catch (SQLException sQLException) { ss = false; System.out.println(sQLException + "-----------Insert query failed-------"); rs = null; } finally { dbConnManager.con_close(dbConn); } return ss; }
From source file:com.grant.data.ItemDAO.java
public List getItemCatogaryReport(ReportICatogory ric) throws FileNotFoundException, IOException { ResultSet rs = null;// w w w . jav a 2s. c om Connection dbConn = null; List ss = null; try { dbConn = dbConnManager.connect(); Statement stmt = dbConn.createStatement(); String query = "SELECT * FROM grant_item_out WHERE d_in_date BETWEEN '" + ric.getItemIDateStart() + "' AND '" + ric.getItemInDateEnd() + "' AND v_item_name = '" + ric.getItemName() + "'"; //SELECT * FROM grant_item_out WHERE d_in_date BETWEEN '2016-01-07' AND '2016-01-08' AND v_item_name = 'Item 1 chm' //String query = "INSERT INTO grant_item_out(v_item_name,v_item_no,v_ref_code,v_descrip,v_invo_no,i_outwards,i_balance,d_in_date) " + "VALUES( '" + itemName + "','" + itemNo + "','" + refCode + "','"+ description + "','" + invoiceNo + "','" + outwards + "','" + balance + "','"+ itemInDate + "'" + ")"; System.out.println(query); rs = stmt.executeQuery(query); ///////////// HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("lawix10"); HSSFRow rowhead = sheet.createRow((short) 0); //rowhead.createCell((short) 0).setCellValue("Item ID"); rowhead.createCell((short) 1).setCellValue("i_itin_id"); rowhead.createCell((short) 2).setCellValue("v_item_name"); rowhead.createCell((short) 3).setCellValue("v_item_no"); rowhead.createCell((short) 4).setCellValue("v_ref_code"); rowhead.createCell((short) 5).setCellValue("v_descrip"); rowhead.createCell((short) 6).setCellValue("v_invo_no"); rowhead.createCell((short) 7).setCellValue("i_outwards"); rowhead.createCell((short) 8).setCellValue("v_outtype"); rowhead.createCell((short) 9).setCellValue("i_balance"); rowhead.createCell((short) 10).setCellValue("i_unit_price"); rowhead.createCell((short) 11).setCellValue("i_amount"); rowhead.createCell((short) 12).setCellValue("i_sub_total"); rowhead.createCell((short) 13).setCellValue("i_discount"); rowhead.createCell((short) 14).setCellValue("i_total"); rowhead.createCell((short) 15).setCellValue("d_in_date"); rowhead.createCell((short) 16).setCellValue("v_cus_name"); rowhead.createCell((short) 17).setCellValue("v_address"); rowhead.createCell((short) 18).setCellValue("v_payType"); rowhead.createCell((short) 19).setCellValue("v_no"); rowhead.createCell((short) 20).setCellValue("v_order_no"); int i = 1; while (rs.next()) { HSSFRow row = sheet.createRow((short) i); //row.createCell((short) 0).setCellValue(Integer.toString(rs.getInt(0))); row.createCell((short) 1).setCellValue(rs.getString(1)); row.createCell((short) 2).setCellValue(rs.getString(2)); row.createCell((short) 3).setCellValue(rs.getString(3)); row.createCell((short) 4).setCellValue(rs.getString(4)); row.createCell((short) 5).setCellValue(rs.getString(5)); row.createCell((short) 6).setCellValue(rs.getString(6)); row.createCell((short) 7).setCellValue(rs.getString(7)); row.createCell((short) 8).setCellValue(rs.getString(8)); row.createCell((short) 9).setCellValue(rs.getString(9)); row.createCell((short) 10).setCellValue(rs.getString(10)); row.createCell((short) 11).setCellValue(rs.getString(11)); row.createCell((short) 12).setCellValue(rs.getString(12)); row.createCell((short) 13).setCellValue(rs.getString(13)); row.createCell((short) 14).setCellValue(rs.getString(14)); row.createCell((short) 15).setCellValue(rs.getString(15)); row.createCell((short) 16).setCellValue(rs.getString(16)); row.createCell((short) 17).setCellValue(rs.getString(17)); row.createCell((short) 18).setCellValue(rs.getString(18)); row.createCell((short) 19).setCellValue(rs.getString(19)); row.createCell((short) 20).setCellValue(rs.getString(20)); i++; } String yemi = "C:/Users/Isura Amarasinghe/Desktop/test.xls"; //C:/Users/Isura Amarasinghe/Desktop FileOutputStream fileOut = new FileOutputStream(yemi); workbook.write(fileOut); fileOut.close(); /////////// } catch (SQLException sQLException) { System.out.println(sQLException + "-----------Insert query failed-------"); rs = null; } finally { dbConnManager.con_close(dbConn); } return ss; }
From source file:com.grant.data.ItemDAO.java
public List getRefPerfReport(ReportRefCode rrc) throws FileNotFoundException, IOException { ResultSet rs = null;//from w ww.ja v a2s. c o m Connection dbConn = null; List ss = null; try { dbConn = dbConnManager.connect(); Statement stmt = dbConn.createStatement(); String query = "SELECT * FROM grant_item_out WHERE d_in_date BETWEEN '" + rrc.getItemIDateStart() + "' AND '" + rrc.getItemInDateEnd() + "' AND v_ref_code = '" + rrc.getRefCode() + "'"; //SELECT * FROM grant_item_out WHERE d_in_date BETWEEN '2016-01-07' AND '2016-01-08' AND v_item_name = 'Item 1 chm' //String query = "INSERT INTO grant_item_out(v_item_name,v_item_no,v_ref_code,v_descrip,v_invo_no,i_outwards,i_balance,d_in_date) " + "VALUES( '" + itemName + "','" + itemNo + "','" + refCode + "','"+ description + "','" + invoiceNo + "','" + outwards + "','" + balance + "','"+ itemInDate + "'" + ")"; System.out.println(query); rs = stmt.executeQuery(query); ///////////// HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("lawix10"); HSSFRow rowhead = sheet.createRow((short) 0); //rowhead.createCell((short) 0).setCellValue("Item ID"); rowhead.createCell((short) 1).setCellValue("i_itin_id"); rowhead.createCell((short) 2).setCellValue("v_item_name"); rowhead.createCell((short) 3).setCellValue("v_item_no"); rowhead.createCell((short) 4).setCellValue("v_ref_code"); rowhead.createCell((short) 5).setCellValue("v_descrip"); rowhead.createCell((short) 6).setCellValue("v_invo_no"); rowhead.createCell((short) 7).setCellValue("i_outwards"); rowhead.createCell((short) 8).setCellValue("v_outtype"); rowhead.createCell((short) 9).setCellValue("i_balance"); rowhead.createCell((short) 10).setCellValue("i_unit_price"); rowhead.createCell((short) 11).setCellValue("i_amount"); rowhead.createCell((short) 12).setCellValue("i_sub_total"); rowhead.createCell((short) 13).setCellValue("i_discount"); rowhead.createCell((short) 14).setCellValue("i_total"); rowhead.createCell((short) 15).setCellValue("d_in_date"); rowhead.createCell((short) 16).setCellValue("v_cus_name"); rowhead.createCell((short) 17).setCellValue("v_address"); rowhead.createCell((short) 18).setCellValue("v_payType"); rowhead.createCell((short) 19).setCellValue("v_no"); rowhead.createCell((short) 20).setCellValue("v_order_no"); int i = 1; while (rs.next()) { HSSFRow row = sheet.createRow((short) i); //row.createCell((short) 0).setCellValue(Integer.toString(rs.getInt(0))); row.createCell((short) 1).setCellValue(rs.getString(1)); row.createCell((short) 2).setCellValue(rs.getString(2)); row.createCell((short) 3).setCellValue(rs.getString(3)); row.createCell((short) 4).setCellValue(rs.getString(4)); row.createCell((short) 5).setCellValue(rs.getString(5)); row.createCell((short) 6).setCellValue(rs.getString(6)); row.createCell((short) 7).setCellValue(rs.getString(7)); row.createCell((short) 8).setCellValue(rs.getString(8)); row.createCell((short) 9).setCellValue(rs.getString(9)); row.createCell((short) 10).setCellValue(rs.getString(10)); row.createCell((short) 11).setCellValue(rs.getString(11)); row.createCell((short) 12).setCellValue(rs.getString(12)); row.createCell((short) 13).setCellValue(rs.getString(13)); row.createCell((short) 14).setCellValue(rs.getString(14)); row.createCell((short) 15).setCellValue(rs.getString(15)); row.createCell((short) 16).setCellValue(rs.getString(16)); row.createCell((short) 17).setCellValue(rs.getString(17)); row.createCell((short) 18).setCellValue(rs.getString(18)); row.createCell((short) 19).setCellValue(rs.getString(19)); row.createCell((short) 20).setCellValue(rs.getString(20)); i++; } String yemi = "C:/Users/Isura Amarasinghe/Desktop/ref.xls"; //C:/Users/Isura Amarasinghe/Desktop FileOutputStream fileOut = new FileOutputStream(yemi); workbook.write(fileOut); fileOut.close(); /////////// } catch (SQLException sQLException) { System.out.println(sQLException + "-----------Insert query failed-------"); rs = null; } finally { dbConnManager.con_close(dbConn); } return ss; }
From source file:com.haulmont.cuba.gui.export.ExcelExporter.java
License:Apache License
public void exportTable(Table<Entity> table, List<Table.Column> columns, Boolean exportExpanded, ExportDisplay display, List<String> filterDescription, String fileName, ExportMode exportMode) { if (display == null) { throw new IllegalArgumentException("ExportDisplay is null"); }//from w w w . ja va 2 s . co m createWorkbookWithSheet(); createFonts(); createFormats(); int r = 0; if (filterDescription != null) { for (r = 0; r < filterDescription.size(); r++) { String line = filterDescription.get(r); HSSFRow row = sheet.createRow(r); if (r == 0) { HSSFRichTextString richTextFilterName = new HSSFRichTextString(line); richTextFilterName.applyFont(boldFont); row.createCell(0).setCellValue(richTextFilterName); } else { row.createCell(0).setCellValue(line); } } r++; } HSSFRow row = sheet.createRow(r); createAutoColumnSizers(columns.size()); float maxHeight = sheet.getDefaultRowHeightInPoints(); CellStyle headerCellStyle = wb.createCellStyle(); headerCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); for (Table.Column column : columns) { String caption = column.getCaption(); int countOfReturnSymbols = StringUtils.countMatches(caption, "\n"); if (countOfReturnSymbols > 0) { maxHeight = Math.max(maxHeight, (countOfReturnSymbols + 1) * sheet.getDefaultRowHeightInPoints()); headerCellStyle.setWrapText(true); } } row.setHeightInPoints(maxHeight); for (int c = 0; c < columns.size(); c++) { Table.Column column = columns.get(c); String caption = column.getCaption(); HSSFCell cell = row.createCell(c); HSSFRichTextString richTextString = new HSSFRichTextString(caption); richTextString.applyFont(boldFont); cell.setCellValue(richTextString); ExcelAutoColumnSizer sizer = new ExcelAutoColumnSizer(); sizer.notifyCellValue(caption, boldFont); sizers[c] = sizer; cell.setCellStyle(headerCellStyle); } CollectionDatasource datasource = table.getDatasource(); if (exportMode == ExportMode.SELECTED_ROWS && table.getSelected().size() > 0) { Set<Entity> selected = table.getSelected(); List<Entity> ordered = ((Collection<Entity>) datasource.getItems()).stream().filter(selected::contains) .collect(Collectors.toList()); for (Entity item : ordered) { createRow(table, columns, 0, ++r, item.getId()); } } else { if (table instanceof TreeTable) { TreeTable treeTable = (TreeTable) table; HierarchicalDatasource ds = treeTable.getDatasource(); if (table.isAggregatable()) { r = createAggregatableRow(table, columns, ++r, 1, datasource); } for (Object itemId : ds.getRootItemIds()) { r = createHierarhicalRow(treeTable, columns, exportExpanded, r, itemId); } } else if (table instanceof GroupTable && datasource instanceof GroupDatasource && ((GroupDatasource) datasource).hasGroups()) { GroupDatasource ds = (GroupDatasource) datasource; if (table.isAggregatable()) { r = createAggregatableRow(table, columns, ++r, 1, datasource); } for (Object item : ds.rootGroups()) { r = createGroupRow((GroupTable) table, columns, ++r, (GroupInfo) item, 0); } } else { if (table.isAggregatable()) { r = createAggregatableRow(table, columns, ++r, 1, datasource); } for (Object itemId : datasource.getItemIds()) { createRow(table, columns, 0, ++r, itemId); } } } for (int c = 0; c < columns.size(); c++) { sheet.setColumnWidth(c, sizers[c].getWidth() * COL_WIDTH_MAGIC); } ByteArrayOutputStream out = new ByteArrayOutputStream(); try { wb.write(out); } catch (IOException e) { throw new RuntimeException("Unable to write document", e); } if (fileName == null) { fileName = messages.getTools().getEntityCaption(datasource.getMetaClass()); } display.show(new ByteArrayDataProvider(out.toByteArray()), fileName + ".xls", ExportFormat.XLS); }
From source file:com.haulmont.cuba.gui.export.ExcelExporter.java
License:Apache License
public void exportDataGrid(DataGrid<Entity> dataGrid, List<DataGrid.Column> columns, ExportDisplay display, List<String> filterDescription, String fileName, ExportMode exportMode) { if (display == null) { throw new IllegalArgumentException("ExportDisplay is null"); }//from www . ja v a 2 s .c om createWorkbookWithSheet(); createFonts(); createFormats(); int r = 0; if (filterDescription != null) { for (r = 0; r < filterDescription.size(); r++) { String line = filterDescription.get(r); HSSFRow row = sheet.createRow(r); if (r == 0) { HSSFRichTextString richTextFilterName = new HSSFRichTextString(line); richTextFilterName.applyFont(boldFont); row.createCell(0).setCellValue(richTextFilterName); } else { row.createCell(0).setCellValue(line); } } r++; } HSSFRow row = sheet.createRow(r); createAutoColumnSizers(columns.size()); float maxHeight = sheet.getDefaultRowHeightInPoints(); CellStyle headerCellStyle = wb.createCellStyle(); headerCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); for (DataGrid.Column column : columns) { String caption = column.getCaption(); int countOfReturnSymbols = StringUtils.countMatches(caption, "\n"); if (countOfReturnSymbols > 0) { maxHeight = Math.max(maxHeight, (countOfReturnSymbols + 1) * sheet.getDefaultRowHeightInPoints()); headerCellStyle.setWrapText(true); } } row.setHeightInPoints(maxHeight); for (int c = 0; c < columns.size(); c++) { DataGrid.Column column = columns.get(c); String caption = column.getCaption(); HSSFCell cell = row.createCell(c); HSSFRichTextString richTextString = new HSSFRichTextString(caption); richTextString.applyFont(boldFont); cell.setCellValue(richTextString); ExcelAutoColumnSizer sizer = new ExcelAutoColumnSizer(); sizer.notifyCellValue(caption, boldFont); sizers[c] = sizer; cell.setCellStyle(headerCellStyle); } CollectionDatasource datasource = dataGrid.getDatasource(); if (exportMode == ExportMode.SELECTED_ROWS && dataGrid.getSelected().size() > 0) { Set<Entity> selected = dataGrid.getSelected(); List<Entity> ordered = ((Collection<Entity>) datasource.getItems()).stream().filter(selected::contains) .collect(Collectors.toList()); for (Entity item : ordered) { createDataGridRow(dataGrid, columns, 0, ++r, item.getId()); } } else { for (Object itemId : datasource.getItemIds()) { createDataGridRow(dataGrid, columns, 0, ++r, itemId); } } for (int c = 0; c < columns.size(); c++) { sheet.setColumnWidth(c, sizers[c].getWidth() * COL_WIDTH_MAGIC); } ByteArrayOutputStream out = new ByteArrayOutputStream(); try { wb.write(out); } catch (IOException e) { throw new RuntimeException("Unable to write document", e); } if (fileName == null) { fileName = messages.getTools().getEntityCaption(datasource.getMetaClass()); } display.show(new ByteArrayDataProvider(out.toByteArray()), fileName + ".xls", ExportFormat.XLS); }
From source file:com.haulmont.cuba.gui.export.ExcelExporter.java
License:Apache License
protected int createAggregatableRow(Table table, List<Table.Column> columns, int rowNumber, int aggregatableRow, CollectionDatasource datasource) { HSSFRow row = sheet.createRow(rowNumber); Map<Object, Object> results = table.getAggregationResults(); int i = 0;//w ww . j a va 2 s . c om for (Table.Column column : columns) { AggregationInfo agr = column.getAggregation(); if (agr != null) { Object agregationResult = results.get(agr.getPropertyPath()); if (agregationResult != null) { HSSFCell cell = row.createCell(i); formatValueCell(cell, agregationResult, null, i, rowNumber, 0, null); } } i++; } return rowNumber; }
From source file:com.haulmont.cuba.gui.export.ExcelExporter.java
License:Apache License
protected int createGroupRow(GroupTable table, List<Table.Column> columns, int rowNumber, GroupInfo groupInfo, int groupNumber) { GroupDatasource ds = table.getDatasource(); HSSFRow row = sheet.createRow(rowNumber); Map<Object, Object> aggregations = table.isAggregatable() ? table.getAggregationResults(groupInfo) : Collections.emptyMap(); int i = 0;//from w ww. j a v a2 s .c o m int initialGroupNumber = groupNumber; for (Table.Column column : columns) { if (i == initialGroupNumber) { HSSFCell cell = row.createCell(i); Object val = groupInfo.getValue(); if (val == null) { val = messages.getMessage(getClass(), "excelExporter.empty"); } Collection children = table.getDatasource().getGroupItemIds(groupInfo); if (children.isEmpty()) { return rowNumber; } Integer groupChildCount = null; if (table.isShowItemsCountForGroup()) { groupChildCount = children.size(); } Object captionValue = val; Element xmlDescriptor = column.getXmlDescriptor(); if (xmlDescriptor != null && StringUtils.isNotEmpty(xmlDescriptor.attributeValue("captionProperty"))) { String captionProperty = xmlDescriptor.attributeValue("captionProperty"); Object itemId = children.iterator().next(); Instance item = ds.getItem(itemId); captionValue = item.getValueEx(captionProperty); } @SuppressWarnings("unchecked") GroupTable.GroupCellValueFormatter<Entity> groupCellValueFormatter = table .getGroupCellValueFormatter(); if (groupCellValueFormatter != null) { // disable separate "(N)" printing groupChildCount = null; List<Entity> groupItems = ((Collection<Object>) ds.getGroupItemIds(groupInfo)).stream() .map((Function<Object, Entity>) ds::getItem).collect(Collectors.toList()); GroupTable.GroupCellContext<Entity> cellContext = new GroupTable.GroupCellContext<>(groupInfo, captionValue, metadataTools.format(captionValue), groupItems); captionValue = groupCellValueFormatter.format(cellContext); } MetaPropertyPath columnId = (MetaPropertyPath) column.getId(); formatValueCell(cell, captionValue, columnId, groupNumber++, rowNumber, 0, groupChildCount); } else { AggregationInfo agr = column.getAggregation(); if (agr != null) { Object aggregationResult = aggregations.get(agr.getPropertyPath()); if (aggregationResult != null) { HSSFCell cell = row.createCell(i); formatValueCell(cell, aggregationResult, null, i, rowNumber, 0, null); } } } i++; } int oldRowNumber = rowNumber; List<GroupInfo> children = ds.getChildren(groupInfo); if (children.size() > 0) { for (GroupInfo child : children) { rowNumber = createGroupRow(table, columns, ++rowNumber, child, groupNumber); } } else { Collection<Object> itemIds = ds.getGroupItemIds(groupInfo); for (Object itemId : itemIds) { createRow(table, columns, groupNumber, ++rowNumber, itemId); } } sheet.groupRow(oldRowNumber + 1, rowNumber); return rowNumber; }
From source file:com.haulmont.cuba.gui.export.ExcelExporter.java
License:Apache License
protected void createRow(Table table, List<Table.Column> columns, int startColumn, int rowNumber, Object itemId) {/* w w w . j a va2s . c o m*/ if (startColumn >= columns.size()) { return; } HSSFRow row = sheet.createRow(rowNumber); Instance instance = table.getDatasource().getItem(itemId); int level = 0; if (table instanceof TreeTable) { level = ((TreeTable) table).getLevel(itemId); } for (int c = startColumn; c < columns.size(); c++) { HSSFCell cell = row.createCell(c); Table.Column column = columns.get(c); Object cellValue = null; MetaPropertyPath propertyPath = null; if (column.getId() instanceof MetaPropertyPath) { propertyPath = (MetaPropertyPath) column.getId(); Table.Printable printable = table.getPrintable(column); if (printable != null) { cellValue = printable.getValue((Entity) instance); } else { Element xmlDescriptor = column.getXmlDescriptor(); if (xmlDescriptor != null && StringUtils.isNotEmpty(xmlDescriptor.attributeValue("captionProperty"))) { String captionProperty = xmlDescriptor.attributeValue("captionProperty"); cellValue = InstanceUtils.getValueEx(instance, captionProperty); } else { cellValue = InstanceUtils.getValueEx(instance, propertyPath.getPath()); } if (column.getFormatter() != null) cellValue = column.getFormatter().format(cellValue); } } else { Table.Printable printable = table.getPrintable(column); if (printable != null) { cellValue = printable.getValue((Entity) instance); } } formatValueCell(cell, cellValue, propertyPath, c, rowNumber, level, null); } }
From source file:com.haulmont.cuba.gui.export.ExcelExporter.java
License:Apache License
protected void createDataGridRow(DataGrid dataGrid, List<DataGrid.Column> columns, int startColumn, int rowNumber, Object itemId) { if (startColumn >= columns.size()) { return;/* w w w .ja v a2 s . c om*/ } HSSFRow row = sheet.createRow(rowNumber); Instance instance = dataGrid.getDatasource().getItem(itemId); int level = 0; for (int c = startColumn; c < columns.size(); c++) { HSSFCell cell = row.createCell(c); DataGrid.Column column = columns.get(c); Object cellValue; MetaPropertyPath propertyPath = null; if (column.getPropertyPath() != null) { propertyPath = column.getPropertyPath(); cellValue = InstanceUtils.getValueEx(instance, propertyPath.getPath()); if (column.getFormatter() != null) { cellValue = column.getFormatter().format(cellValue); } } else { DataGrid.ColumnGenerator generator = dataGrid.getColumnGenerator(column.getId()); DataGrid.ColumnGeneratorEvent event = new DataGrid.ColumnGeneratorEvent(dataGrid, instance, column.getId()); cellValue = generator.getValue(event); } formatValueCell(cell, cellValue, propertyPath, c, rowNumber, level, null); } }
From source file:com.haulmont.mp2xls.writer.LocalizationBatchExcelWriter.java
License:Apache License
public static void exportToXls(LocalizationsBatch localizations, String outputXls) throws IOException { FileOutputStream fileOut = new FileOutputStream(outputXls); HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet worksheet = workbook.createSheet("localizations"); HSSFCellStyle systemStyle = workbook.createCellStyle(); systemStyle.setFillForegroundColor(HSSFColor.RED.index); systemStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); HSSFRow row = worksheet.createRow(0); row.createCell(0).setCellValue("Project path"); row.createCell(1).setCellValue(localizations.getProjectDirectory()); HSSFRow headLine = worksheet.createRow(5); headLine.createCell(0).setCellValue("Path to File"); headLine.createCell(1).setCellValue("Parameter Name"); Map<String, Integer> localeColumn = new HashMap<>(); int colCount = 1; for (String localeId : localizations.getLocalizationIds()) { if (localizations.getScanLocalizationIds().contains(localeId == null ? "en" : localeId)) { String id = localeId == null ? "default" : localeId; headLine.createCell(++colCount).setCellValue(id); localeColumn.put(localeId, colCount); }/*from w w w .j av a 2s .c o m*/ } Integer currentRow = headLine.getRowNum(); for (String folder : localizations.getMessagesLocalizations().keySet()) { Set<MessagesLocalization> locales = localizations.getMessagesLocalizations().get(folder); Set<String> parameters = new HashSet<>(); for (MessagesLocalization locale : locales) { if (localizations.getScanLocalizationIds() .contains(locale.getLocaleId() == null ? "en" : locale.getLocaleId())) parameters.addAll(locale.getMessages().keySet()); } for (String parameter : parameters) { row = worksheet.createRow(++currentRow); HSSFCell cell = row.createCell(0); cell.setCellValue(folder); if (MessagesFolderReader.systemKeys.contains(parameter)) { cell.setCellStyle(systemStyle); row.setZeroHeight(true); } cell = row.createCell(1); cell.setCellValue(parameter); if (MessagesFolderReader.systemKeys.contains(parameter)) { cell.setCellStyle(systemStyle); } for (MessagesLocalization locale : locales) { if (localizations.getScanLocalizationIds() .contains(locale.getLocaleId() == null ? "en" : locale.getLocaleId())) { Integer columnNum = localeColumn.get(locale.getLocaleId()); cell = row.createCell(columnNum); cell.setCellValue(locale.getMessages().get(parameter)); } } } } worksheet.setAutoFilter(new CellRangeAddress(headLine.getRowNum(), worksheet.getLastRowNum(), 0, colCount)); worksheet.createFreezePane(0, headLine.getRowNum() + 1); /* for (int i = 0; i < colCount; i++){ worksheet.autoSizeColumn(i); worksheet.setColumnWidth(i, worksheet.getColumnWidth(i) + 100); } */ workbook.write(fileOut); fileOut.flush(); fileOut.close(); }