/** * Specifies if the defined name is a local name, and if so, which sheet it is on. * * @param index if greater than 0, the defined name is a local name and the value MUST be a 0-based index * to the collection of sheets as they appear in the workbook. * @throws IllegalArgumentException if the sheet index is invalid. */ public void setSheetIndex(int index){ int lastSheetIx = _book.getNumberOfSheets() - 1; if (index < -1 || index > lastSheetIx) { throw new IllegalArgumentException("Sheet index (" + index +") is out of range" + (lastSheetIx == -1 ? "" : (" (0.." + lastSheetIx + ")"))); } _definedNameRec.setSheetNumber(index + 1); }
private static List<Integer> getSheetsIndexes(String[] params, HSSFWorkbook workbook) { List<Integer> list = new ArrayList<>(); list.addAll(getIndexesByIdArray(params)); list.addAll(getIndexesByName(params, workbook)); if (0 == list.size()) { int size = workbook.getNumberOfSheets(); for (int i = 0; i < size; i++) { list.add(i); } } return list; }
System.out.println("done"); for(int i = 0; i < wb.getNumberOfSheets(); i++){ HSSFSheet sheet = wb.getSheetAt(i); if(initDrawing) {
for(int i=0;i<_wb.getNumberOfSheets();i++) { HSSFSheet sheet = _wb.getSheetAt(i); if(sheet == null) { continue; }
private void updateFormulasForShift(FormulaShifter formulaShifter) { int sheetIndex = _workbook.getSheetIndex(this); short externSheetIndex = _book.checkExternSheet(sheetIndex); // update formulas on this sheet that point to rows which have been moved _sheet.updateFormulasAfterCellShift(formulaShifter, externSheetIndex); // update formulas on other sheets that point to rows that have been moved on this sheet int nSheets = _workbook.getNumberOfSheets(); for (int i = 0; i < nSheets; i++) { InternalSheet otherSheet = _workbook.getSheetAt(i).getSheet(); if (otherSheet == this._sheet) { continue; } short otherExtSheetIx = _book.checkExternSheet(i); otherSheet.updateFormulasAfterCellShift(formulaShifter, otherExtSheetIx); } _workbook.getWorkbook().updateNamesAfterCellShift(formulaShifter); }
for(int sheetNum=0; sheetNum<workbook.getNumberOfSheets(); sheetNum++) { HSSFSheet s = workbook.getSheetAt(sheetNum); for (Row row : s) {
for (int sheetNum = 0; sheetNum < workbook.getNumberOfSheets(); sheetNum++) { HSSFSheet s = workbook.getSheetAt(sheetNum); for (Row row : s) { for (int sheetNum = 0; sheetNum < workbook.getNumberOfSheets(); sheetNum++) { HSSFSheet s = workbook.getSheetAt(sheetNum); for (Row row : s) {
private String[] getAllSpreadsheets(HSSFWorkbook wb) { String[] spreadsheets = new String[wb.getNumberOfSheets()]; for (int i = 0; i < wb.getNumberOfSheets(); i++) { spreadsheets[i] = wb.getSheetName(i); } return spreadsheets; }
private static List<Integer> getSheetsIndexes(String[] params, HSSFWorkbook workbook) { List<Integer> list = new ArrayList<>(); list.addAll(getIndexesByIdArray(params)); list.addAll(getIndexesByName(params, workbook)); if (0 == list.size()) { int size = workbook.getNumberOfSheets(); for (int i = 0; i < size; i++) { list.add(i); } } return list; }
private static List<Integer> getSheetsIndexes(String[] params, HSSFWorkbook workbook) { List<Integer> list = new ArrayList<Integer>(); list.addAll(getIndexesByIdArray(params)); list.addAll(getIndexesByName(params, workbook)); if (0 == list.size()) { int size = workbook.getNumberOfSheets(); for (int i = 0; i < size; i++) { list.add(i); } } return list; }
public static List<String> getCellOfAllSheets (File file, int row, int cell) throws IOException { HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(file)); List<String> rows = new ArrayList<>(workbook.getNumberOfSheets()); for (int numberOfSheet = 0; numberOfSheet < workbook.getNumberOfSheets(); numberOfSheet++) { HSSFSheet sheet = workbook.getSheetAt(numberOfSheet); rows.add(sheet.getRow(row).getCell(cell).getStringCellValue()); } return rows; }
public static void main( String [] args ) { try { InputStream input = POIExample.class.getResourceAsStream( "qa.xls" ); POIFSFileSystem fs = new POIFSFileSystem( input ); HSSFWorkbook wb = new HSSFWorkbook(fs); for (int i = 0; i < wb.getNumberOfSheets(); i++) { HSSFSheet sheet = wb.getSheetAt(i); // Do your stuff } } catch ( IOException ex ) { ex.printStackTrace(); } }
protected Map<String, Table> readCodeData(HSSFWorkbook book) { Map<String, Table> tableMap = new LinkedHashMap<String, Table>(); for (int i = 0; i < book.getNumberOfSheets(); ++i) { HSSFSheet sheet = book.getSheetAt(i); Table table = getTable(sheet); if (table != null) { tableMap.put(table.getTableName(), table); } } setupChildLinks(tableMap); return tableMap; }
protected void copyPictures() { for (int sheetNumber = 0; sheetNumber < templateWorkbook.getNumberOfSheets(); sheetNumber++) { HSSFSheet templateSheet = templateWorkbook.getSheetAt(sheetNumber); HSSFSheet resultSheet = resultWorkbook.getSheetAt(sheetNumber); copyPicturesFromTemplateToResult(templateSheet, resultSheet); } }
protected void copyPictures() { for (int sheetNumber = 0; sheetNumber < templateWorkbook.getNumberOfSheets(); sheetNumber++) { HSSFSheet templateSheet = templateWorkbook.getSheetAt(sheetNumber); HSSFSheet resultSheet = resultWorkbook.getSheetAt(sheetNumber); copyPicturesFromTemplateToResult(templateSheet, resultSheet); } }
void initDrawings(){ DrawingManager2 mgr = workbook.findDrawingGroup(); if(mgr != null) { for(int i=0; i < getNumberOfSheets(); i++) { getSheetAt(i).getDrawingPatriarch(); } } else { workbook.createDrawingGroup(); } }
void initDrawings(){ DrawingManager2 mgr = workbook.findDrawingGroup(); if(mgr != null) { for(int i=0; i < getNumberOfSheets(); i++) { getSheetAt(i).getDrawingPatriarch(); } } else { workbook.createDrawingGroup(); } }
public void actionPerformed(ActionEvent e) { //Create a new sheet then search for the sheet and make sure that the //sheetPane shows it. HSSFSheet newSheet = wb.createSheet(); for (int i=0; i<wb.getNumberOfSheets();i++) { HSSFSheet sheet = wb.getSheetAt(i); if (newSheet == sheet) { sheetPane.insertTab(wb.getSheetName(i), null, makeSheetView(sheet), null, i); } } } }
public void actionPerformed(ActionEvent e) { //Create a new sheet then search for the sheet and make sure that the //sheetPane shows it. HSSFSheet newSheet = wb.createSheet(); for (int i=0; i<wb.getNumberOfSheets();i++) { HSSFSheet sheet = wb.getSheetAt(i); if (newSheet == sheet) { sheetPane.insertTab(wb.getSheetName(i), null, makeSheetView(sheet), null, i); } } } }
private void createReqUrlSheet(PoiWorkBook workBook, ReqUrl reqUrl) { PoiWorkSheet sheet = workBook.createSheet(reqUrl.getSheetName(workBook.getWorkBook().getNumberOfSheets())); sheet.nextRow(); sheet.createTitleCells(1.5, reqUrl.getMethod(), reqUrl.getUrl()); sheet.nextRow(2); for (ParamType paramType : ParamType.values()) { if (this.createParamSheet(sheet, paramType, reqUrl)) { sheet.nextRow(3); } } }