krotequity.blogg.se

Let's expand on the content of each switch case above. Next, let's retrieve the first sheet of the file and iterate through each row: Sheet sheet = workbook.getSheetAt(0) ĭefault: data.get(new Integer(i)).add(" ") Īpache POI has different methods for reading each type of data. Workbook workbook = new XSSFWorkbook(file) Public int getRowHeight(int row) Deprecated.First, let's open the file from a given location: FileInputStream file = new FileInputStream(new File(fileLocation)) Returns: the column format, or the default format if no override is Public CellView getColumnView(int col) Gets the column width for the specified column Returns: the column width, or the default width if the column has no Public int getColumnWidth(int col) Deprecated. Returns: the column format, or NULL if the column has no specific format Gets the column format for the specified column Use getColumnView and the CellView bean instead Public CellFormat getColumnFormat(int col) Deprecated. Public SheetSettings getSettings() Gets the settings used on a particular sheet Public Range getMergedCells() Gets the cells which have been merged on this sheet Public Hyperlink getHyperlinks() Gets the hyperlinks on this sheet Queried - all numerical cells are ignored. This method differsįrom the findCell method in that only cells with labels are Public LabelCell findLabelCell( contents) Gets the cell whose contents match the string passed in.Įfficiently the algorithm will perform. Parameters: pattern - the regular expression string to match firstCol - the first column within the range firstRow - the first row of the rang lastCol - the last column within the range lastRow - the last row within the range reverse - indicates whether to perform a reverse search or not Public Cell findCell( pattern,īoolean reverse) Gets the cell whose contents match the regular expressionstring passed in. Returns: the Cell whose contents match the parameter, null if not found Parameters: contents - the string to match firstCol - the first column within the range firstRow - the first row of the range lastCol - the last column within the range lastRow - the last row within the range reverse - indicates whether to perform a reverse search or not Public Cell findCell( contents,īoolean reverse) Gets the cell whose contents match the string passed in. Returns: the Cell whose contents match the paramter, null if not found Parameters: contents - the string to match On a row by row basis, so the lower the row number, the more If no match is found, then null is returned. Public Cell findCell( contents) Gets the cell whose contents match the string passed in. Returns: whether or not the sheet is protected in favour of the getSettings() methodĭetermines whether the sheet is protected Returns: whether or not the sheet is hidden Public getName() Gets the name of this sheet Returns: the cells on the specified column

Parameters: col - the column whose cells are to be returned Public Cell getColumn(int col) Gets all the cells on the specified column Parameters: row - the rows whose cells are to be returned Public Cell getRow(int row) Gets all the cells on the specified row Returns: the number of columns in this sheet Public int getColumns() Returns the number of columns in this sheet Returns: the number of rows in this sheet Public int getRows() Returns the number of rows in this sheet

Method is identical to calling getCell(CellReferenceHelper.getColumn(loc),ĬellReferenceHelper.getRow(loc)) and its implicit performance Public Cell getCell( loc) Returns the cell for the specified location eg. Returns: the cell at the specified co-ordinates Parameters: column - the column number row - the row number Then (unless it is the first cell of the group) a blank cell If a column/row combination forms part of a merged group of cells

Int row) Returns the cell specified at this row and at this column. Gets the settings used on a particular sheetĭeprecated. Gets the row height for the specified column Gets the cells which have been merged on this sheetĪccessor for the number of images on the sheet Gets the column width for the specified column Returns the number of columns in this sheet Use getColumnView and the CellView bean insteadĪccessor for the page breaks on this sheet Gets all the cells on the specified columnĭeprecated. Returns the cell for the specified location eg. Returns the cell specified at this row and at this column. Gets the cell whose contents match the string passed in. Gets the cell whose contents match the regular expressionstring passed in. Provides a handle to the individualĬells, or lines of cells (grouped by Row or Column)įindCell( pattern, Interface Sheet All Known Subinterfaces: WritableSheet SUMMARY: NESTED | FIELD | CONSTR | METHOD