public class SheetUtil
extends java.lang.Object
Constructor and Description |
---|
SheetUtil() |
Modifier and Type | Method and Description |
---|---|
static boolean |
canComputeColumnWidht(Font font)
Check if the Fonts are installed correctly so that Java can compute the size of
columns.
|
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
|
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 cellspublic static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells)
sheet
- the sheet to calculatecolumn
- 0-based index of the columnuseMergedCells
- whether to use merged cellspublic 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 canComputeColumnWidht(Font font)
font
- The Font that is used in the Cellpublic 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.
Copyright 2016 The Apache Software Foundation or its licensors, as applicable.