|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.ss.util.SheetUtil
public class SheetUtil
Helper methods for when working with Usermodel sheets
Constructor Summary | |
---|---|
SheetUtil()
|
Method Summary | |
---|---|
static boolean |
containsCell(CellRangeAddress cr,
int rowIx,
int colIx)
|
static double |
getCellWidth(Cell cell,
int defaultCharWidth,
DataFormatter formatter,
boolean useMergedCells)
Compute width of a single cell |
static Cell |
getCellWithMerges(Sheet sheet,
int rowIx,
int colIx)
Return the cell, taking account of merged regions. |
static double |
getColumnWidth(Sheet sheet,
int column,
boolean useMergedCells)
Compute width of a column and return the result |
static double |
getColumnWidth(Sheet sheet,
int column,
boolean useMergedCells,
int firstRow,
int lastRow)
Compute width of a column based on a subset of the rows and return the result |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SheetUtil()
Method Detail |
---|
public static double getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells)
cell
- the cell whose width is to be calculateddefaultCharWidth
- the width of a single characterformatter
- formatter used to prepare the text to be measureduseMergedCells
- whether to use merged cells
public static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells)
sheet
- the sheet to calculatecolumn
- 0-based index of the columnuseMergedCells
- whether to use merged cells
public static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells, int firstRow, int lastRow)
sheet
- the sheet to calculatecolumn
- 0-based index of the columnuseMergedCells
- whether to use merged cellsfirstRow
- 0-based index of the first row to consider (inclusive)lastRow
- 0-based index of the last row to consider (inclusive)
public static boolean containsCell(CellRangeAddress cr, int rowIx, int colIx)
public static Cell getCellWithMerges(Sheet sheet, int rowIx, int colIx)
If the cell at the given co-ordinates is a merged cell, this will return the primary (top-left) most cell of the merged region.
If the cell at the given co-ordinates is not in a merged region, then will return the cell itself.
If there is no cell defined at the given co-ordinates, will return null.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |