public class ExcelPOITool
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
class |
ExcelPOITool.ExcelCell |
class |
ExcelPOITool.ExcelRow |
class |
ExcelPOITool.ExcelSheet |
Modifier and Type | Field and Description |
---|---|
static short |
COLOR_BLUE |
static short |
COLOR_GREEN |
static short |
COLOR_GREY |
static short |
COLOR_RED |
static short |
COLOR_WHITE |
static java.lang.String |
DATE_CELL_BLUE |
static java.lang.String |
DATE_CELL_GREEN |
static java.lang.String |
DATE_CELL_GREY |
static java.lang.String |
DATE_CELL_RED |
static java.lang.String |
DATE_CELL_WHITE |
static java.lang.String |
DATETIME_CELL_BLUE |
static java.lang.String |
DATETIME_CELL_GREEN |
static java.lang.String |
DATETIME_CELL_GREY |
static java.lang.String |
DATETIME_CELL_RED |
static java.lang.String |
DATETIME_CELL_WHITE |
static java.lang.String |
FORMULA_CELL_BLUE |
static java.lang.String |
FORMULA_CELL_GREEN |
static java.lang.String |
FORMULA_CELL_GREY |
static java.lang.String |
FORMULA_CELL_RED |
static java.lang.String |
FORMULA_CELL_WHITE |
static java.lang.String |
FORMULA_HEAD_GREY |
static java.lang.String |
FORMULA_HEAD_WHITE |
static java.lang.String |
NUMERIC_CELL_BLUE |
static java.lang.String |
NUMERIC_CELL_GREEN |
static java.lang.String |
NUMERIC_CELL_GREY |
static java.lang.String |
NUMERIC_CELL_RED |
static java.lang.String |
NUMERIC_CELL_WHITE |
static java.lang.String |
NUMERIC_HEAD_GREY |
static java.lang.String |
NUMERIC_HEAD_WHITE |
static java.lang.String |
STRING_CELL_BLUE |
static java.lang.String |
STRING_CELL_GREEN |
static java.lang.String |
STRING_CELL_GREY |
static java.lang.String |
STRING_CELL_RED |
static java.lang.String |
STRING_CELL_WHITE |
static java.lang.String |
STRING_HEAD_GREY |
static java.lang.String |
STRING_HEAD_WHITE |
java.util.Map<java.lang.String,org.apache.poi.ss.usermodel.CellStyle> |
STYLES
Custom styles (not static = belongs to each workbook)
|
static org.apache.poi.ss.usermodel.CellType |
TYPE_FORMULA |
static org.apache.poi.ss.usermodel.CellType |
TYPE_NUMERIC |
static org.apache.poi.ss.usermodel.CellType |
TYPE_STRING |
Constructor and Description |
---|
ExcelPOITool()
Constructor (empty workbook)
|
ExcelPOITool(byte[] data)
Constructor (workbook from byte array data)
|
ExcelPOITool(Grant g,
DocumentDB doc)
Constructor (workbook from document)
|
ExcelPOITool(java.io.InputStream in)
Constructor (workbook from input stream)
|
ExcelPOITool(java.lang.String path)
Constructor (workbook from existing file)
|
Modifier and Type | Method and Description |
---|---|
org.apache.poi.ss.usermodel.Sheet |
add(ExcelPOITool.ExcelSheet sheet) |
org.apache.poi.ss.usermodel.Sheet |
add(ExcelPOITool.ExcelSheet sheet,
int autoSizeColumns,
int freezeRows) |
void |
generate(java.io.OutputStream out) |
byte[] |
generateToByteArray() |
void |
generateToFile(java.lang.String fileName) |
java.lang.String |
generateToString() |
static org.apache.poi.ss.usermodel.CellStyle |
getDateCellStyle(org.apache.poi.ss.usermodel.Workbook wb,
short bgcolor,
boolean head) |
static org.apache.poi.ss.usermodel.CellStyle |
getDateTimeCellStyle(org.apache.poi.ss.usermodel.Workbook wb,
short bgcolor,
boolean head) |
static org.apache.poi.ss.usermodel.CellStyle |
getFormulaCellStyle(org.apache.poi.ss.usermodel.Workbook wb,
short bgcolor,
boolean head) |
static org.apache.poi.ss.usermodel.CellStyle |
getNumericCellStyle(org.apache.poi.ss.usermodel.Workbook wb,
short bgcolor,
boolean head) |
static org.apache.poi.ss.usermodel.CellStyle |
getStringCellStyle(org.apache.poi.ss.usermodel.Workbook wb,
short bgcolor,
boolean head) |
org.apache.poi.ss.usermodel.Workbook |
getWorkbook() |
ExcelPOITool.ExcelCell |
newCell(int cellIndex,
ObjectField f,
java.lang.String value) |
ExcelPOITool.ExcelCell |
newCell(int cellIndex,
java.lang.String content) |
ExcelPOITool.ExcelCell |
newCell(int cellIndex,
java.lang.String content,
org.apache.poi.ss.usermodel.CellType type) |
ExcelPOITool.ExcelCell |
newCell(int cellIndex,
java.lang.String content,
org.apache.poi.ss.usermodel.CellType type,
java.lang.String styleName) |
ExcelPOITool.ExcelCell |
newCell(int cellIndex,
java.lang.String content,
org.apache.poi.ss.usermodel.CellType type,
java.lang.String styleName,
ObjectField field) |
ExcelPOITool.ExcelRow |
newRow(int rowIndex) |
ExcelPOITool.ExcelSheet |
newSheet(java.lang.String label) |
org.apache.poi.ss.usermodel.Sheet |
update(ExcelPOITool.ExcelSheet sheet) |
void |
updateFormulas(org.apache.poi.ss.usermodel.Sheet sheet) |
public static final short COLOR_WHITE
public static final short COLOR_BLUE
public static final short COLOR_RED
public static final short COLOR_GREEN
public static final short COLOR_GREY
public static final org.apache.poi.ss.usermodel.CellType TYPE_STRING
public static final org.apache.poi.ss.usermodel.CellType TYPE_NUMERIC
public static final org.apache.poi.ss.usermodel.CellType TYPE_FORMULA
public static final java.lang.String STRING_HEAD_WHITE
public static final java.lang.String STRING_HEAD_GREY
public static final java.lang.String NUMERIC_HEAD_WHITE
public static final java.lang.String NUMERIC_HEAD_GREY
public static final java.lang.String FORMULA_HEAD_WHITE
public static final java.lang.String FORMULA_HEAD_GREY
public static final java.lang.String STRING_CELL_WHITE
public static final java.lang.String STRING_CELL_BLUE
public static final java.lang.String STRING_CELL_RED
public static final java.lang.String STRING_CELL_GREEN
public static final java.lang.String STRING_CELL_GREY
public static final java.lang.String NUMERIC_CELL_WHITE
public static final java.lang.String NUMERIC_CELL_BLUE
public static final java.lang.String NUMERIC_CELL_RED
public static final java.lang.String NUMERIC_CELL_GREEN
public static final java.lang.String NUMERIC_CELL_GREY
public static final java.lang.String FORMULA_CELL_WHITE
public static final java.lang.String FORMULA_CELL_BLUE
public static final java.lang.String FORMULA_CELL_RED
public static final java.lang.String FORMULA_CELL_GREEN
public static final java.lang.String FORMULA_CELL_GREY
public static final java.lang.String DATE_CELL_WHITE
public static final java.lang.String DATE_CELL_BLUE
public static final java.lang.String DATE_CELL_RED
public static final java.lang.String DATE_CELL_GREEN
public static final java.lang.String DATE_CELL_GREY
public static final java.lang.String DATETIME_CELL_WHITE
public static final java.lang.String DATETIME_CELL_BLUE
public static final java.lang.String DATETIME_CELL_RED
public static final java.lang.String DATETIME_CELL_GREEN
public static final java.lang.String DATETIME_CELL_GREY
public java.util.Map<java.lang.String,org.apache.poi.ss.usermodel.CellStyle> STYLES
public ExcelPOITool() throws java.lang.Exception
java.lang.Exception
public ExcelPOITool(java.lang.String path) throws java.lang.Exception
java.lang.Exception
public ExcelPOITool(byte[] data) throws java.lang.Exception
java.lang.Exception
public ExcelPOITool(Grant g, DocumentDB doc) throws java.lang.Exception
java.lang.Exception
public ExcelPOITool(java.io.InputStream in) throws java.lang.Exception
java.lang.Exception
public ExcelPOITool.ExcelSheet newSheet(java.lang.String label)
public ExcelPOITool.ExcelRow newRow(int rowIndex)
public ExcelPOITool.ExcelCell newCell(int cellIndex, ObjectField f, java.lang.String value)
public ExcelPOITool.ExcelCell newCell(int cellIndex, java.lang.String content)
public ExcelPOITool.ExcelCell newCell(int cellIndex, java.lang.String content, org.apache.poi.ss.usermodel.CellType type)
public ExcelPOITool.ExcelCell newCell(int cellIndex, java.lang.String content, org.apache.poi.ss.usermodel.CellType type, java.lang.String styleName)
public ExcelPOITool.ExcelCell newCell(int cellIndex, java.lang.String content, org.apache.poi.ss.usermodel.CellType type, java.lang.String styleName, ObjectField field)
public static org.apache.poi.ss.usermodel.CellStyle getStringCellStyle(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
public static org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
public static org.apache.poi.ss.usermodel.CellStyle getDateCellStyle(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
public static org.apache.poi.ss.usermodel.CellStyle getDateTimeCellStyle(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
public static org.apache.poi.ss.usermodel.CellStyle getFormulaCellStyle(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
public org.apache.poi.ss.usermodel.Workbook getWorkbook()
public org.apache.poi.ss.usermodel.Sheet update(ExcelPOITool.ExcelSheet sheet)
public org.apache.poi.ss.usermodel.Sheet add(ExcelPOITool.ExcelSheet sheet)
public org.apache.poi.ss.usermodel.Sheet add(ExcelPOITool.ExcelSheet sheet, int autoSizeColumns, int freezeRows)
public java.lang.String generateToString() throws java.lang.Exception
java.lang.Exception
public byte[] generateToByteArray() throws java.lang.Exception
java.lang.Exception
public void generateToFile(java.lang.String fileName) throws java.lang.Exception
java.lang.Exception
public void generate(java.io.OutputStream out) throws java.lang.Exception
java.lang.Exception
public void updateFormulas(org.apache.poi.ss.usermodel.Sheet sheet)
Copyright (c)2006-2014 Simplicite Software. All Rights Reserved.