Package fr.becpg.repo.helper

Class ExcelHelper

java.lang.Object

fr.becpg.repo.helper.ExcelHelper

public class ExcelHelper
extends Object

ExcelHelper class.

Version:

$Id: $Id

Author:

matthieu

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	ExcelHelper.ExcelCellStyles
static interface	ExcelHelper.ExcelFieldTitleProvider

Constructor Summary

Constructors

Constructor	Description
ExcelHelper()

Method Summary

Modifier and Type	Method	Description
static int	appendExcelField(List<AttributeExtractorServiceImpl.AttributeExtractorStructure> computedFields, String prefix, Map<String,Object> item, org.apache.poi.xssf.usermodel.XSSFSheet sheet, org.apache.poi.ss.usermodel.Row row, int cellnum, int rowNum, List<Locale> supportedLocales, ExcelHelper.ExcelCellStyles excelCellStyles)	appendExcelField.
static int	appendExcelHeader(List<AttributeExtractorServiceImpl.AttributeExtractorStructure> fields, String prefix, String titlePrefix, org.apache.poi.ss.usermodel.Row headerRow, org.apache.poi.ss.usermodel.Row labelRow, ExcelHelper.ExcelCellStyles excelCellStyles, org.apache.poi.xssf.usermodel.XSSFSheet sheet, int cellnum, ExcelHelper.ExcelFieldTitleProvider titleProvider, List<Locale> supportedLocales)	appendExcelHeader.
static org.apache.poi.xssf.usermodel.XSSFColor	beCPGHeaderColor()	beCPGHeaderColor.
static org.apache.poi.xssf.usermodel.XSSFColor	beCPGHeaderTextColor()	beCPGHeaderTextColor.
static org.apache.poi.xssf.usermodel.XSSFColor	createGreenColor()	createGreenColor.
static org.apache.poi.xssf.usermodel.XSSFColor	createRedColor()	createRedColor.
static boolean	isExcelType(Serializable value)	isExcelType.
private static String	shiftFormula(String formula, int rowNum, org.apache.poi.xssf.usermodel.XSSFSheet sheet)

Methods inherited from class java.lang.Object

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

Constructor Details

ExcelHelper

public ExcelHelper()

Method Details

appendExcelField

public static int appendExcelField(List<AttributeExtractorServiceImpl.AttributeExtractorStructure> computedFields,
 String prefix,
 Map<String,Object> item,
 org.apache.poi.xssf.usermodel.XSSFSheet sheet,
 org.apache.poi.ss.usermodel.Row row,
 int cellnum,
 int rowNum,
 List<Locale> supportedLocales,
 ExcelHelper.ExcelCellStyles excelCellStyles)

appendExcelField.

Parameters:

computedFields - a List object.

prefix - a String object.

item - a Map object.

sheet - a XSSFSheet object.

row - a Row object.

cellnum - a int.

rowNum - a int.

supportedLocales - a List object.

excelCellStyles - a ExcelHelper.ExcelCellStyles object

Returns:

a int.

shiftFormula

private static String shiftFormula(String formula,
 int rowNum,
 org.apache.poi.xssf.usermodel.XSSFSheet sheet)

isExcelType

public static boolean isExcelType(Serializable value)

isExcelType.

Parameters:

value - a Serializable object.

Returns:

a boolean.

appendExcelHeader

public static int appendExcelHeader(List<AttributeExtractorServiceImpl.AttributeExtractorStructure> fields,
 String prefix,
 String titlePrefix,
 org.apache.poi.ss.usermodel.Row headerRow,
 org.apache.poi.ss.usermodel.Row labelRow,
 ExcelHelper.ExcelCellStyles excelCellStyles,
 org.apache.poi.xssf.usermodel.XSSFSheet sheet,
 int cellnum,
 ExcelHelper.ExcelFieldTitleProvider titleProvider,
 List<Locale> supportedLocales)

appendExcelHeader.

Parameters:

fields - a List object.

prefix - a String object.

titlePrefix - a String object.

headerRow - a Row object.

labelRow - a Row object.

sheet - a XSSFSheet object.

cellnum - a int.

titleProvider - a ExcelHelper.ExcelFieldTitleProvider object.

supportedLocales - a List object.

excelCellStyles - a ExcelHelper.ExcelCellStyles object

Returns:

a int.

createGreenColor

public static org.apache.poi.xssf.usermodel.XSSFColor createGreenColor()

createGreenColor.

Returns:

a XSSFColor object

createRedColor

public static org.apache.poi.xssf.usermodel.XSSFColor createRedColor()

createRedColor.

Returns:

a XSSFColor object

beCPGHeaderColor

public static org.apache.poi.xssf.usermodel.XSSFColor beCPGHeaderColor()

beCPGHeaderColor.

Returns:

a XSSFColor object

beCPGHeaderTextColor

public static org.apache.poi.xssf.usermodel.XSSFColor beCPGHeaderTextColor()

beCPGHeaderTextColor.

Returns:

a XSSFColor object