String ref = new CellRangeAddress(getFirstRowNum(), getLastRowNum(), minCell, maxCell).formatAsString(); if(worksheet.isSetDimension()) { worksheet.getDimension().setRef(ref);
@Override public Collection<IColumn> getColumns() { if (_columns == null) { _columns = new HashMap<String, IColumn>(); XSSFRow headers = _workbook.getSheetAt(_index).getRow(_workbook.getSheetAt(_index) .getFirstRowNum()); for (Iterator<Cell> cit = headers.cellIterator(); cit.hasNext();) { Cell cell = cit.next(); _columns.put(cell.getStringCellValue().trim(), new ExcelColumn(cell)); _columnIDs.add(cell.getStringCellValue().trim()); } } return _columns.values(); }
/** * Get all rows in current sheet. Skip header it there is one * * @return List of rows */ private List<XSSFRow> getRows() { List<XSSFRow> effectiveRows = new ArrayList<>(); int firstRowNumber = 0; XSSFSheet sheet = workBook.getSheet(sheetName); if ("Описание" .equals(sheet.getRow(sheet.getFirstRowNum()).cellIterator().next().getStringCellValue())) { // Check if there is a header on the current shit. If so, skip it firstRowNumber++; } for (int i = firstRowNumber; i <= sheet.getLastRowNum(); i++) { effectiveRows.add(sheet.getRow(i)); } return effectiveRows; }
/** * Get all rows in current sheet. Skip header it there is one * * @return List of rows */ private List<XSSFRow> getRows() { List<XSSFRow> effectiveRows = new ArrayList<>(); int firstRowNumber = 0; XSSFSheet sheet = workBook.getSheet(collectionName); if ("Описание" .equals(sheet.getRow(sheet.getFirstRowNum()).cellIterator().next().getStringCellValue())) { // Check if there is a header on the current shit. If so, skip it firstRowNumber++; } for (int i = firstRowNumber; i <= sheet.getLastRowNum(); i++) { effectiveRows.add(sheet.getRow(i)); } return effectiveRows; }
XSSFWorkbook workbook = new XSSFWorkbook(file); XSSFSheet sheet = workbook.getSheetAt(0); int rowStart = sheet.getFirstRowNum(); int rowEnd = sheet.getLastRowNum() + 1; int count = workbook.getNumberOfSheets();
throws KlabException { List<Object> ret = new ArrayList<Object>(); for (int i = _workbook.getSheetAt(_index).getFirstRowNum() + 1; i < _workbook.getSheetAt(_index) .getLastRowNum(); i++) { XSSFRow row = _workbook.getSheetAt(_index).getRow(i);
for (int i = sheet.getFirstRowNum(); i <= sheet.getLastRowNum(); i++)
// Open workbook and sheet final XSSFWorkbook workbook = new XSSFWorkbook(new File("filename.xlsx")); final XSSFSheet sheet = workbook.getSheetAt(0); // Iterate rows final int firstRowNumber = sheet.getFirstRowNum(); final int lastRowNumber = sheet.getLastRowNum(); for (int rowNumber = firstRowNumber; rowNumber < lastRowNumber; rowNumber++ ) { final XSSFRow row = sheet.getRow(rowNumber); if (row == null) continue; // Iterate columns final int firstColumnNumber = row.getFirstCellNum(); final int lastColumnNumber = row.getLastCellNum(); for (int columnNumber = firstColumnNumber; columnNumber < lastColumnNumber; columnNumber++ ) { final XSSFCell cell = row.getCell(firstColumnNumber); if (cell == null) continue; // Make some changes cell.setCellValue("new Value"); } } // Save changes workbook.write(new FileOutputStream("newFilename.xlsx"));
if (sheet != null) for (int rowNum = sheet.getFirstRowNum(); rowNum <= sheet.getLastRowNum(); rowNum++)
for (int i = sourceSheet.getFirstRowNum(); i <= sourceSheet.getLastRowNum(); i++) { XSSFRow sourceRow = sourceSheet.getRow(i); SXSSFRow targetRow = (SXSSFRow) targetSheet.createRow(i);
String ref = new CellRangeAddress(getFirstRowNum(), getLastRowNum(), minCell, maxCell).formatAsString(); if(worksheet.isSetDimension()) { worksheet.getDimension().setRef(ref);
for (int rowNumber = oldSheet.getFirstRowNum(); rowNumber < oldSheet.getLastRowNum(); rowNumber++) { final XSSFRow oldRow = oldSheet.getRow(rowNumber); if (oldRow != null) {