Package overit.geocall.util

Class XlsxUtils

java.lang.Object

overit.geocall.util.XlsxUtils

public class XlsxUtils
extends Object

Utility class used to handle the Xlsx

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	XlsxUtils.ConvertImageUnits

Field Summary

Fields

Modifier and Type	Field	Description
static final int	COLUMN_CHAR_SIZE
static final int	COLUMN_WIDTH_MULTIPLIER	The method setColumnWidth(int columnIndex,int width) sets the width in units of 1/256th of a character width, so we use this multiplier to obtain the correct width
static final String	DEFAULT_HEADER_FONT
static final int	DEFAULT_ROW_HEIGHT
static final String	DEFAULT_TABLEVIEW_FONT
static final String	DEFAULT_TITLE_FONT
static final int	EMU_PER_MM	Modified to support EMU - English Metric Units - used within the OOXML workbooks, this multoplier is used to convert between measurements in millimetres and in EMUs
static final int	EXPAND_COLUMN	If the image will be larger than the column, the behaviour plans to expand the column width
static final int	EXPAND_ROW	If the image will be higher than the row, the behaviour plans to expand the row height
static final int	EXPAND_ROW_AND_COLUMN	If the image will be higher than the row, or larger than the column, the behaviour plans to expand the row height and the column width
static final int	MAX_COL_NUMBER
static final int	MAX_COLUMN_CHAR
static final int	MAX_ROW_NUMBER
static final int	OVERLAY_ROW_AND_COLUMN	If the image will be higher than the row or larger than the column, it will be positioned over the rows and columns, without expanding them
static final String	XLS_TO_XLSX

Constructor Summary

Constructors

Constructor	Description
XlsxUtils()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

MAX_ROW_NUMBER

public static final int MAX_ROW_NUMBER

MAX_COL_NUMBER

public static final int MAX_COL_NUMBER

COLUMN_CHAR_SIZE

public static final int COLUMN_CHAR_SIZE

XLS_TO_XLSX

public static final String XLS_TO_XLSX

See Also:

• Constant Field Values

DEFAULT_TABLEVIEW_FONT

public static final String DEFAULT_TABLEVIEW_FONT

See Also:

• Constant Field Values

DEFAULT_HEADER_FONT

public static final String DEFAULT_HEADER_FONT

See Also:

• Constant Field Values

DEFAULT_TITLE_FONT

public static final String DEFAULT_TITLE_FONT

See Also:

• Constant Field Values

DEFAULT_ROW_HEIGHT

public static final int DEFAULT_ROW_HEIGHT

See Also:

• Constant Field Values

MAX_COLUMN_CHAR

public static final int MAX_COLUMN_CHAR

See Also:

• Constant Field Values

COLUMN_WIDTH_MULTIPLIER

public static final int COLUMN_WIDTH_MULTIPLIER

The method setColumnWidth(int columnIndex,int width) sets the width in units of 1/256th of a character width, so we use this multiplier to obtain the correct width

See Also:

• Constant Field Values

EMU_PER_MM

public static final int EMU_PER_MM

Modified to support EMU - English Metric Units - used within the OOXML workbooks, this multoplier is used to convert between measurements in millimetres and in EMUs

See Also:

• Constant Field Values

EXPAND_ROW

public static final int EXPAND_ROW

If the image will be higher than the row, the behaviour plans to expand the row height

See Also:

• Constant Field Values

EXPAND_COLUMN

public static final int EXPAND_COLUMN

If the image will be larger than the column, the behaviour plans to expand the column width

See Also:

• Constant Field Values

EXPAND_ROW_AND_COLUMN

public static final int EXPAND_ROW_AND_COLUMN

If the image will be higher than the row, or larger than the column, the behaviour plans to expand the row height and the column width

See Also:

• Constant Field Values

OVERLAY_ROW_AND_COLUMN

public static final int OVERLAY_ROW_AND_COLUMN

If the image will be higher than the row or larger than the column, it will be positioned over the rows and columns, without expanding them

See Also:

• Constant Field Values

Constructor Details

XlsxUtils

public XlsxUtils()