public class SheetUtil
extends java.lang.Object
Constructor and Description |
---|
SheetUtil() |
Modifier and Type | Method and Description |
---|---|
static boolean |
canComputeColumnWidth(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)
Deprecated.
3.15 beta 2. Use
CellRangeAddressBase.isInRange(int, int) . |
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
|
static int |
getDefaultCharWidth(Workbook wb)
Get default character width using the Workbook's default font
|
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)@Internal public static int getDefaultCharWidth(Workbook wb)
wb
- the workbook to get the default character width frompublic static boolean canComputeColumnWidth(Font font)
font
- The Font that is used in the Cellpublic static boolean containsCell(CellRangeAddress cr, int rowIx, int colIx)
CellRangeAddressBase.isInRange(int, int)
.cr
- the cell range to check inrowIx
- the row to checkcolIx
- the column to checkpublic 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 2017 The Apache Software Foundation or its licensors, as applicable.