Package com.bld.common.spreadsheet.utils

Class ExcelUtils

java.lang.Object

com.bld.common.spreadsheet.utils.ExcelUtils

public class ExcelUtils
extends Object

The Class ExcelUtils.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	ANNOTATION_DATA	The Constant ANNOTATION_DATA.
static final String	ANNOTATIONS	The Constant ANNOTATIONS.
static final short	AUTO_SIZE_HEIGHT	The Constant AUTO_SIZE_HEIGHT.
static final String	ENV_SHEET_NAME	The Constant ENV_SHEET_NAME.

Constructor Summary

Constructors

Constructor	Description
ExcelUtils()

Method Summary

Modifier and Type	Method	Description
static String	coordinateCalculation(int row, int idColumn, boolean isBlockColumn, boolean isBlockRow)	Calcolo coordinate function.
static Double	evaluate(String exprenssionIndex, String param, Number value)	Evaluate.
static String	getKeyColumn(org.apache.poi.ss.usermodel.Sheet sheet, String key)	Gets the key column.
static String	getNameParameter(String parameter)	Gets the name parameter.
static <T> Class<T>	getTClass(Object entity)	Gets the t class.
static <T> Class<T>	getTClass(Object entity, int i)	Gets the t class.
static Matcher	matcher(String param, String function)	Matcher.
static short	rowHeight(int rowHeight)	Hight row.
static short	widthColumn(int widthColumn)	Width column.

Methods inherited from class java.lang.Object

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

Field Details

ANNOTATIONS

public static final String ANNOTATIONS

The Constant ANNOTATIONS.

See Also:

• Constant Field Values

ANNOTATION_DATA

public static final String ANNOTATION_DATA

The Constant ANNOTATION_DATA.

See Also:

• Constant Field Values

AUTO_SIZE_HEIGHT

public static final short AUTO_SIZE_HEIGHT

The Constant AUTO_SIZE_HEIGHT.

See Also:

• Constant Field Values

ENV_SHEET_NAME

public static final String ENV_SHEET_NAME

The Constant ENV_SHEET_NAME.

See Also:

• Constant Field Values

Constructor Details

ExcelUtils

public ExcelUtils()

Method Details

getNameParameter

public static String getNameParameter(String parameter)

Gets the name parameter.

Parameters:

parameter - the parameter

Returns:

the name parameter

coordinateCalculation

public static String coordinateCalculation(int row,
 int idColumn,
 boolean isBlockColumn,
 boolean isBlockRow)

Calcolo coordinate function.

Parameters:

row - the row

idColumn - the id column

isBlockColumn - the is block column

isBlockRow - the is block row

Returns:

the string

getKeyColumn

public static String getKeyColumn(org.apache.poi.ss.usermodel.Sheet sheet,
 String key)

Gets the key column.

Parameters:

sheet - the sheet

key - the key

Returns:

the key column

widthColumn

public static short widthColumn(int widthColumn)

Width column.

Parameters:

widthColumn - the width column

Returns:

the short

rowHeight

public static short rowHeight(int rowHeight)

Hight row.

Parameters:

rowHeight - the hight row

Returns:

the short

getTClass

public static <T> Class<T> getTClass(Object entity)

Gets the t class.

Type Parameters:

T - the generic type

Parameters:

entity - the entity

Returns:

the t class

getTClass

public static <T> Class<T> getTClass(Object entity,
 int i)

Gets the t class.

Type Parameters:

T - the generic type

Parameters:

entity - the entity

i - the i

Returns:

the t class

evaluate

public static Double evaluate(String exprenssionIndex,
 String param,
 Number value)

Evaluate.

Parameters:

exprenssionIndex - the exprenssion index

param - the param

value - the value

Returns:

the double

matcher

public static Matcher matcher(String param,
 String function)

Matcher.

Parameters:

param - the param

function - the function

Returns:

the matcher