Package org.rogatio.circlead.util

Class ExcelUtil

java.lang.Object

org.rogatio.circlead.util.ExcelUtil

public class ExcelUtil
extends java.lang.Object

The Class ExcelUtil allows writing Data to Microsoft-Excel.

Author:

Matthias Wegner

Constructor Summary

Constructors

Constructor	Description
ExcelUtil()

Method Summary

Modifier and Type	Method	Description
static org.apache.poi.xssf.usermodel.XSSFCellStyle	addColorBackground(org.apache.poi.xssf.usermodel.XSSFCellStyle style, byte r, byte g, byte b)	Adds the color background.
static org.apache.poi.xssf.usermodel.XSSFCellStyle	getBoldStyle(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook)	Gets the bold style.
static java.util.Calendar	getDateValue(org.apache.poi.ss.usermodel.Cell cell)	Gets the date value.
static org.apache.poi.xssf.usermodel.XSSFRow	getFirstRow(org.apache.poi.xssf.usermodel.XSSFSheet sheet)	Gets the first row.
static org.apache.poi.xssf.usermodel.XSSFRow	getFirstRow(org.apache.poi.xssf.usermodel.XSSFWorkbook wb, java.lang.String sheetName)	Gets the first row.
static org.apache.poi.xssf.usermodel.XSSFSheet	getFirstSheet(org.apache.poi.xssf.usermodel.XSSFWorkbook wb)	Gets the first sheet.
static org.apache.poi.ss.usermodel.Cell	getHeaderCell(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.xssf.usermodel.XSSFRow headerRow)	Gets the header cell.
static java.lang.String	getHeaderValue(org.apache.poi.ss.usermodel.Cell cell)	Gets the header value.
static java.lang.String	getHeaderValue(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.xssf.usermodel.XSSFRow headerRow)	Gets the header value.
static double	getNumericValue(org.apache.poi.ss.usermodel.Cell cell)	Gets the numeric value.
static org.apache.poi.xssf.usermodel.XSSFRichTextString	getRichString(java.lang.String content, org.apache.poi.xssf.usermodel.XSSFWorkbook workbook, boolean bold, int textHeight)	Gets the rich string.
static java.lang.String	getStringValue(org.apache.poi.ss.usermodel.Cell cell)	Gets the string value.
static boolean	isDateValue(org.apache.poi.ss.usermodel.Cell cell)	Checks if is date value.
static boolean	isNumericValue(org.apache.poi.ss.usermodel.Cell cell)	Checks if is numeric value.
static boolean	isStringValue(org.apache.poi.ss.usermodel.Cell cell)	Checks if is string value.
static org.apache.poi.xssf.usermodel.XSSFWorkbook	readExcel(java.lang.String fileName)	Read excel.
static void	setBorder(org.apache.poi.ss.usermodel.BorderStyle style, org.apache.poi.ss.util.CellRangeAddress range, org.apache.poi.xssf.usermodel.XSSFSheet sheet)
static void	setBorder(org.apache.poi.xssf.usermodel.XSSFCellStyle cellStyle, org.apache.poi.ss.usermodel.BorderStyle bs, int r, int g, int b)
static void	setBorder(org.apache.poi.xssf.usermodel.XSSFCellStyle cellStyle, org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide side, org.apache.poi.ss.usermodel.BorderStyle bs, int r, int g, int b)
static void	setPrintArea(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook, org.apache.poi.xssf.usermodel.XSSFSheet spreadsheet, int maxRow, int maxColumn, boolean fitToPage)	Sets the print area.
static void	writeExcel(java.lang.String filename, java.util.List<java.util.Map<Parameter,java.lang.Object>> dataMap, java.util.List<Parameter> headerRow)	Write excel.

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelUtil

public ExcelUtil()

Method Detail

setBorder

public static void setBorder(org.apache.poi.xssf.usermodel.XSSFCellStyle cellStyle,
                             org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide side,
                             org.apache.poi.ss.usermodel.BorderStyle bs,
                             int r,
                             int g,
                             int b)

setBorder

public static void setBorder(org.apache.poi.ss.usermodel.BorderStyle style,
                             org.apache.poi.ss.util.CellRangeAddress range,
                             org.apache.poi.xssf.usermodel.XSSFSheet sheet)

setBorder

public static void setBorder(org.apache.poi.xssf.usermodel.XSSFCellStyle cellStyle,
                             org.apache.poi.ss.usermodel.BorderStyle bs,
                             int r,
                             int g,
                             int b)

addColorBackground

public static org.apache.poi.xssf.usermodel.XSSFCellStyle addColorBackground(org.apache.poi.xssf.usermodel.XSSFCellStyle style,
                                                                             byte r,
                                                                             byte g,
                                                                             byte b)

Adds the color background.

Parameters:

style - the style

r - the r

g - the g

b - the b

Returns:

the XSSF cell style

writeExcel

public static void writeExcel(java.lang.String filename,
                              java.util.List<java.util.Map<Parameter,java.lang.Object>> dataMap,
                              java.util.List<Parameter> headerRow)

Write excel.

Parameters:

filename - the filename

dataMap - the data map

headerRow - the header row

setPrintArea

public static void setPrintArea(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook,
                                org.apache.poi.xssf.usermodel.XSSFSheet spreadsheet,
                                int maxRow,
                                int maxColumn,
                                boolean fitToPage)

Sets the print area.

Parameters:

workbook - the workbook

spreadsheet - the spreadsheet

maxRow - the max row

maxColumn - the max column

fitToPage - the fit to page

readExcel

public static org.apache.poi.xssf.usermodel.XSSFWorkbook readExcel(java.lang.String fileName)

Read excel.

Parameters:

fileName - the file name

Returns:

the XSSF workbook

getFirstSheet

public static org.apache.poi.xssf.usermodel.XSSFSheet getFirstSheet(org.apache.poi.xssf.usermodel.XSSFWorkbook wb)

Gets the first sheet.

Parameters:

wb - the wb

Returns:

the first sheet

getFirstRow

public static org.apache.poi.xssf.usermodel.XSSFRow getFirstRow(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

Gets the first row.

Parameters:

sheet - the sheet

Returns:

the first row

getFirstRow

public static org.apache.poi.xssf.usermodel.XSSFRow getFirstRow(org.apache.poi.xssf.usermodel.XSSFWorkbook wb,
                                                                java.lang.String sheetName)

Gets the first row.

Parameters:

wb - the wb

sheetName - the sheet name

Returns:

the first row

isStringValue

public static boolean isStringValue(org.apache.poi.ss.usermodel.Cell cell)

Checks if is string value.

Parameters:

cell - the cell

Returns:

true, if is string value

getHeaderValue

public static java.lang.String getHeaderValue(org.apache.poi.ss.usermodel.Cell cell)

Gets the header value.

Parameters:

cell - the cell

Returns:

the header value

getHeaderValue

public static java.lang.String getHeaderValue(org.apache.poi.ss.usermodel.Cell cell,
                                              org.apache.poi.xssf.usermodel.XSSFRow headerRow)

Gets the header value.

Parameters:

cell - the cell

headerRow - the header row

Returns:

the header value

getHeaderCell

public static org.apache.poi.ss.usermodel.Cell getHeaderCell(org.apache.poi.ss.usermodel.Cell cell,
                                                             org.apache.poi.xssf.usermodel.XSSFRow headerRow)

Gets the header cell.

Parameters:

cell - the cell

headerRow - the header row

Returns:

the header cell

getStringValue

public static java.lang.String getStringValue(org.apache.poi.ss.usermodel.Cell cell)

Gets the string value.

Parameters:

cell - the cell

Returns:

the string value

getNumericValue

public static double getNumericValue(org.apache.poi.ss.usermodel.Cell cell)

Gets the numeric value.

Parameters:

cell - the cell

Returns:

the numeric value

isNumericValue

public static boolean isNumericValue(org.apache.poi.ss.usermodel.Cell cell)

Checks if is numeric value.

Parameters:

cell - the cell

Returns:

true, if is numeric value

isDateValue

public static boolean isDateValue(org.apache.poi.ss.usermodel.Cell cell)

Checks if is date value.

Parameters:

cell - the cell

Returns:

true, if is date value

getDateValue

public static java.util.Calendar getDateValue(org.apache.poi.ss.usermodel.Cell cell)

Gets the date value.

Parameters:

cell - the cell

Returns:

the date value

getRichString

public static org.apache.poi.xssf.usermodel.XSSFRichTextString getRichString(java.lang.String content,
                                                                             org.apache.poi.xssf.usermodel.XSSFWorkbook workbook,
                                                                             boolean bold,
                                                                             int textHeight)

Gets the rich string.

Parameters:

content - the content

workbook - the workbook

bold - the bold

textHeight - the text height

Returns:

the rich string

getBoldStyle

public static org.apache.poi.xssf.usermodel.XSSFCellStyle getBoldStyle(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook)

Gets the bold style.

Parameters:

workbook - the workbook

Returns:

the bold style