/** * this method writes the data into sheet * * @param sheet * sheet of embedded excel * @param categoryData * category values * @param valuesData * data values * @since POI 4.0.0 */ protected void fillSheet(XSSFSheet sheet, XDDFDataSource<?> categoryData, XDDFNumericalDataSource<?> valuesData) { int numOfPoints = categoryData.getPointCount(); for (int i = 0; i < numOfPoints; i++) { XSSFRow row = this.getRow(sheet, i + 1); // first row is for title this.getCell(row, categoryData.getColIndex()).setCellValue(categoryData.getPointAt(i).toString()); this.getCell(row, valuesData.getColIndex()).setCellValue(valuesData.getPointAt(i).doubleValue()); } }
private void fillNumCache(CTNumData cache, int numOfPoints, XDDFNumericalDataSource<?> data) { String formatCode = data.getFormatCode(); if (formatCode == null) { if (cache.isSetFormatCode()) { cache.unsetFormatCode(); } } else { cache.setFormatCode(formatCode); } cache.setPtArray(null); // unset old values if (cache.isSetPtCount()) { cache.getPtCount().setVal(numOfPoints); } else { cache.addNewPtCount().setVal(numOfPoints); } for (int i = 0; i < numOfPoints; ++i) { Object value = data.getPointAt(i); if (value != null) { CTNumVal ctNumVal = cache.addNewPt(); ctNumVal.setIdx(i); ctNumVal.setV(value.toString()); } } } }
/** * this method writes the data into sheet * * @param sheet * sheet of embedded excel * @param categoryData * category values * @param valuesData * data values * @since POI 4.0.0 */ protected void fillSheet(XSSFSheet sheet, XDDFDataSource<?> categoryData, XDDFNumericalDataSource<?> valuesData) { int numOfPoints = categoryData.getPointCount(); for (int i = 0; i < numOfPoints; i++) { XSSFRow row = this.getRow(sheet, i + 1); // first row is for title this.getCell(row, categoryData.getColIndex()).setCellValue(categoryData.getPointAt(i).toString()); this.getCell(row, valuesData.getColIndex()).setCellValue(valuesData.getPointAt(i).doubleValue()); } }
private void fillNumCache(CTNumData cache, int numOfPoints, XDDFNumericalDataSource<?> data) { String formatCode = data.getFormatCode(); if (formatCode == null) { if (cache.isSetFormatCode()) { cache.unsetFormatCode(); } } else { cache.setFormatCode(formatCode); } cache.setPtArray(null); // unset old values if (cache.isSetPtCount()) { cache.getPtCount().setVal(numOfPoints); } else { cache.addNewPtCount().setVal(numOfPoints); } for (int i = 0; i < numOfPoints; ++i) { Object value = data.getPointAt(i); if (value != null) { CTNumVal ctNumVal = cache.addNewPt(); ctNumVal.setIdx(i); ctNumVal.setV(value.toString()); } } } }