org.zkoss.poi.ss.util

Class SheetUtil

java.lang.Object

org.zkoss.poi.ss.util.SheetUtil

public class SheetUtil
extends Object

Helper methods for when working with Usermodel sheets

Author:

Yegor Kozlov

Constructor Summary

Constructors

Constructor and Description
SheetUtil()

Method Summary

Modifier and Type	Method and Description
static String	base64Random16Bytes()
static boolean	containsCell(CellRangeAddress cr, int rowIx, int colIx)
static String	encryptPassword(String password, String hashAlg, String salt64, int spinCount) see [MS_OFFCRYPTO].pdf 2.4.2.4
static double	getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells) Compute width of a single cell
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

SheetUtil

public SheetUtil()

Method Detail

getCellWidth

public static double getCellWidth(Cell cell,
                                  int defaultCharWidth,
                                  DataFormatter formatter,
                                  boolean useMergedCells)

Compute width of a single cell

Parameters:

cell - the cell whose width is to be calculated

defaultCharWidth - the width of a single character

formatter - formatter used to prepare the text to be measured

useMergedCells - whether to use merged cells

Returns:

the width in pixels

getColumnWidth

public static double getColumnWidth(Sheet sheet,
                                    int column,
                                    boolean useMergedCells)

Compute width of a column and return the result

Parameters:

sheet - the sheet to calculate

column - 0-based index of the column

useMergedCells - whether to use merged cells

Returns:

the width in pixels

getColumnWidth

public 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

Parameters:

sheet - the sheet to calculate

column - 0-based index of the column

useMergedCells - whether to use merged cells

firstRow - 0-based index of the first row to consider (inclusive)

lastRow - 0-based index of the last row to consider (inclusive)

Returns:

the width in pixels

containsCell

public static boolean containsCell(CellRangeAddress cr,
                                   int rowIx,
                                   int colIx)

base64Random16Bytes

public static String base64Random16Bytes()

encryptPassword

public static String encryptPassword(String password,
                                     String hashAlg,
                                     String salt64,
                                     int spinCount)

see [MS_OFFCRYPTO].pdf 2.4.2.4

Returns: