/** * @param range * @return * @since POI 4.0.0 */ public String formatRange(CellRangeAddress range) { final XSSFSheet sheet = getSheet(); return (sheet == null) ? null : range.formatAsString(sheet.getSheetName(), true); }
public void plot(XDDFChartData data) { XSSFSheet sheet = getSheet(); for (XDDFChartData.Series series : data.getSeries()) { series.plot(); fillSheet(sheet, series.getCategoryData(), series.getValuesData()); } }
/** * set sheet title in excel file * * @param title * title of sheet * @param column * column index * @return return cell reference * @since POI 4.0.0 */ public CellReference setSheetTitle(String title, int column) { XSSFSheet sheet = getSheet(); XSSFRow row = this.getRow(sheet, 0); XSSFCell cell = this.getCell(row, column); cell.setCellValue(title); this.updateSheetTable(sheet.getTables().get(0).getCTTable(), title, column); return new CellReference(sheet.getSheetName(), 0, column, true, true); }
/** * @param range * @return * @since POI 4.0.0 */ public String formatRange(CellRangeAddress range) { final XSSFSheet sheet = getSheet(); return (sheet == null) ? null : range.formatAsString(sheet.getSheetName(), true); }
public void plot(XDDFChartData data) { XSSFSheet sheet = getSheet(); for (XDDFChartData.Series series : data.getSeries()) { series.plot(); fillSheet(sheet, series.getCategoryData(), series.getValuesData()); } }
/** * set sheet title in excel file * * @param title * title of sheet * @param column * column index * @return return cell reference * @since POI 4.0.0 */ public CellReference setSheetTitle(String title, int column) { XSSFSheet sheet = getSheet(); XSSFRow row = this.getRow(sheet, 0); XSSFCell cell = this.getCell(row, column); cell.setCellValue(title); this.updateSheetTable(sheet.getTables().get(0).getCTTable(), title, column); return new CellReference(sheet.getSheetName(), 0, column, true, true); }