Sheet templateWorkbookSheet = templateWorkbook.getSheet( worksheetNumber ); Sheet targetWorkbookSheet = targetFileWorkbook.getSheet( worksheetNumber ); int templateWorkbookSheetColumns = templateWorkbookSheet.getColumns(); int targetWorkbookSheetColumns = targetWorkbookSheet.getColumns(); if ( templateWorkbookSheetColumns > targetWorkbookSheetColumns ) { return false; int templateWorkbookSheetRows = templateWorkbookSheet.getRows(); int targetWorkbookSheetRows = targetWorkbookSheet.getRows(); if ( templateWorkbookSheetRows > targetWorkbookSheetRows ) { return false; Cell[] templateWorkbookSheetRow = templateWorkbookSheet.getRow( currentRowNumber ); Cell[] targetWorkbookSheetRow = targetWorkbookSheet.getRow( currentRowNumber ); if ( templateWorkbookSheetRow.length > targetWorkbookSheetRow.length ) { return false;
public KCell getCell( int colnr, int rownr ) { Cell cell = sheet.getCell( colnr, rownr ); if ( cell == null ) { return null; } return new XLSCell( cell ); } }
public String getName() { return sheet.getName(); }
w = Workbook.getWorkbook(inputWorkbook); Sheet sheet = w.getSheet(0); for (int j = 0; j < sheet.getRows(); j++) { Cell cell = sheet.getCell(0, j); if(cell.getContents().equalsIgnoreCase(key)){ for (int i = 0; i < sheet.getColumns(); i++) { Cell cel = sheet.getCell(i, j); resultSet.add(cel.getContents());
File xls=new File("url of excel file"); try { Workbook wb=Workbook.getWorkbook(xls); for(int shno=0;shno<wb.getNumberOfSheets();shno++) { Sheet s=wb.getSheet(shno); int rows=s.getRows(); for(int i=0;i<rows;i++) { data=s.getCell(1,i).getContents(); }
Workbook workbook = Workbook.getWorkbook(new File("myfile.xls")); Sheet sheet = workbook.getSheet(0); for (int i = 0; i < sheet.getRows(); i++) { boolean c1Empty = sheet.getCell(0, i).getContents().isEmpty(); boolean c2Empty = sheet.getCell(1, i).getContents().isEmpty(); boolean c3Empty = sheet.getCell(2, i).getContents().isEmpty(); boolean c4Empty = sheet.getCell(3, i).getContents().isEmpty(); if (c1Empty && c2Empty && c3Empty && c4Empty) { throw new RuntimeException("If the first three columns are empty then the fourth column can not empty."); } // Redundant //if (c4Empty && c1Empty && c2Empty && c3Empty) { // throw new RuntimeException("If the fourth column is empty then all the three columns should not be empty."); //} }
private static WritableSheet createSheetCopy(Workbook w, int from, int to, WritableWorkbook writeableWorkbook) throws WriteException { Sheet sheet = w.getSheet(from); WritableSheet newSheet = writeableWorkbook.getSheet(to); // Avoid warning // "Maximum number of format records exceeded. Using default format." Map<CellFormat, WritableCellFormat> definedFormats = new HashMap<CellFormat, WritableCellFormat>(); for (int colIdx = 0; colIdx < sheet.getColumns(); colIdx++) { newSheet.setColumnView(colIdx, sheet.getColumnView(colIdx)); for (int rowIdx = 0; rowIdx < sheet.getRows(); rowIdx++) { if (colIdx == 0) { newSheet.setRowView(rowIdx, sheet.getRowView(rowIdx)); } Cell readCell = sheet.getCell(colIdx, rowIdx); Label label = new Label(colIdx, rowIdx, readCell.getContents()); CellFormat readFormat = readCell.getCellFormat(); if (readFormat != null) { if (!definedFormats.containsKey(readFormat)) { definedFormats.put(readFormat, new WritableCellFormat( readFormat)); } label.setCellFormat(definedFormats.get(readFormat)); } newSheet.addCell(label); } } return newSheet; }
/** * Gets the cell at the bottom right of this range * * @return the cell at the bottom right */ public Cell getBottomRight() { // If the print area exceeds the bounds of the sheet, then handle // it here. The sheet implementation will give a NPE if (column2 >= sheet.getColumns() || row2 >= sheet.getRows()) { return new EmptyCell(column2,row2); } return sheet.getCell(column2, row2); }
/** * Get a specific row from the Excel Worksheet * You can optionally skip the first column of the row to ensure row titles are not pulled into the data set * (The first row is row 1) * * @param rowNumber * @param skipFirstColumn * @return * @throws Exception */ public HashMap<Integer, Cell> getRow(int rowNumber, boolean skipFirstColumn) throws Exception { if (this.selectedSheet.equals(null)) { throw new Exception("No sheet selected. You must select a sheet before trying to get data!"); } else if (rowNumber > this.selectedSheet.getRows()) { throw new Exception("There are only " + this.selectedSheet.getRows() + " rows in this sheet. Unable to select row " + rowNumber + "!"); } HashMap<Integer, Cell> selectedRow = new HashMap<Integer, Cell>(); for (Cell currentCell : this.selectedSheet.getRow(rowNumber - 1)) { selectedRow.put(selectedRow.size() + 1, currentCell); } if (skipFirstColumn) { selectedRow.remove(1); } return selectedRow; }
public int getRows() { return sheet.getRows(); }
if (!(hide && s.getSettings().isHidden())) bw.write("*** " + s.getName() + " ****"); bw.newLine(); for (int i = 0 ; i < s.getRows() ; i++) row = s.getRow(i);
public static JexcelSheetData createSheetData(Sheet sheet, JexcelTransformer transformer){ JexcelSheetData sheetData = new JexcelSheetData(); sheetData.setTransformer(transformer); sheetData.sheet = sheet; sheetData.sheetName = sheet.getName(); sheetData.columnWidth = new int[256]; for(int i = 0; i < 256; i++){ sheetData.columnWidth[i] = sheet.getColumnView(i).getSize(); } int numberOfRows = sheet.getRows(); for(int i = 0; i < numberOfRows; i++){ sheetData.rowDataList.add(JexcelRowData.createRowData(sheet, i, transformer)); } sheetData.mergedCells = sheet.getMergedCells(); return sheetData; }
/** * Constructor which takes the delegate sheet. * * @param delegate the JXL sheet */ JxlSheet(final jxl.Sheet delegate) { super(); this.delegate = delegate; this.numberOfRows = this.delegate.getRows(); this.numberOfColumns = this.delegate.getNumberOfImages(); this.name=this.delegate.getName(); }
public static RowData createRowData(Sheet sheet, int rowNum, JexcelTransformer transformer){ return createRowData(sheet.getName(), sheet.getRow(rowNum), sheet.getRowView(rowNum), transformer); }
Sheet s = ... Colour[] colorings = new Colour[]{Colour.GOLD, Colour.OCEAN_BLUE}; for(int i=0;i<s.getRows();i++){ CellView rowView = s.getRowView(i); WritableCellFormat newFormat = new WritableCellFormat(rowView.getFormat()); newFormat.setBackground(colorings[i%2]); rowView.setFormat(newFormat()); }
public KCell[] getRow( int rownr ) { Cell[] cells = sheet.getRow( rownr ); XLSCell[] xlsCells = new XLSCell[cells.length]; for ( int i = 0; i < cells.length; i++ ) { if ( cells[i] != null ) { xlsCells[i] = new XLSCell( cells[i] ); } } return xlsCells; }
public int getColumns() { return sheet.getColumns(); }
int firstRowHeight = sheet.getRowView(firstRow).getSize(); double firstRowImageHeight = (1 - (y - firstRow)) * firstRowHeight; if (lastRow != firstRow) lastRowHeight = sheet.getRowView(lastRow).getSize(); lastRowImageHeight = (y + height - lastRow) * lastRowHeight; for (int i = 0 ; i < lastRow - firstRow - 1 ; i++) height += sheet.getRowView(firstRow + 1 + i).getSize();
CellView cellView = sheet.getColumnView(firstCol); int firstColWidth = cellView.getSize(); double firstColImageWidth = (1 - (x - firstCol)) * firstColWidth; if (lastCol != firstCol) cellView = sheet.getColumnView(lastCol); lastColWidth = cellView.getSize(); lastColImageWidth = (x + width - lastCol) * lastColWidth; for (int i = 0 ; i < lastCol - firstCol - 1 ; i++) cellView = sheet.getColumnView(firstCol + 1 +i); pointSize = (cellView.getFormat() != null) ? cellView.getFormat().getFont().getPointSize() : DEFAULT_FONT_SIZE;