public class ExcelMLTool
extends java.lang.Object
Microsoft Excel(R) XML toolbox
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CELL_STYLE_DATE
Date cell style
|
static java.lang.String |
CELL_STYLE_DATETIME
Datetime cell style
|
static java.lang.String |
CELL_STYLE_HEADER
Header cell style
|
static java.lang.String |
CELL_STYLE_NORMAL
Normal cell style
|
static java.lang.String |
CELL_TYPE_DATETIME
Datetime cell type
|
static java.lang.String |
CELL_TYPE_NUMBER
Number cell type
|
static java.lang.String |
CELL_TYPE_STRING
Text cell type
|
Constructor and Description |
---|
ExcelMLTool() |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
cell(double d)
ExcelML number cell for double
|
static java.lang.String |
cell(int i)
ExcelML number cell for integer
|
static java.lang.String |
cell(long l)
ExcelML number cell for long integer
|
static java.lang.String |
cell(ObjectField f,
java.lang.String value) |
static java.lang.String |
cell(java.lang.String t)
ExcelML text cell
|
static java.lang.String |
cell(java.lang.String t,
boolean head)
ExcelML text cell
|
static java.lang.String |
cell(java.lang.String value,
java.lang.String type,
boolean head)
Deprecated.
|
static java.lang.String |
cell(java.lang.String value,
java.lang.String type,
java.lang.String style)
ExcelML cell
|
static java.lang.String |
col(int width)
ExcelML column declaration
|
static java.lang.String |
cols(int[] widths)
ExcelML columns declaration
|
static java.lang.String |
cols(java.util.Vector<java.lang.Integer> widths)
ExcelML columns declaration
|
static java.lang.String |
footer()
ExcelML footer
|
static java.lang.String |
formulaCell(java.lang.String formula)
ExcelML formula cell
|
static java.lang.String |
formulaCell(java.lang.String formula,
java.lang.String style)
ExcelML formula cell
|
static java.lang.String |
header()
ExcelML header
|
static java.lang.String |
row(java.lang.String cells)
ExcelML row
|
static java.lang.String |
sheetFooter()
ExcelML sheet footer
|
static java.lang.String |
sheetHeader(java.lang.String label)
ExcelML sheet header
|
static java.lang.String |
sheetHeader(java.lang.String label,
int[] colWidths)
ExcelML sheet header
|
public static final java.lang.String CELL_TYPE_STRING
public static final java.lang.String CELL_TYPE_NUMBER
public static final java.lang.String CELL_TYPE_DATETIME
public static final java.lang.String CELL_STYLE_NORMAL
public static final java.lang.String CELL_STYLE_HEADER
public static final java.lang.String CELL_STYLE_DATETIME
public static final java.lang.String CELL_STYLE_DATE
public static java.lang.String header()
ExcelML header
public static java.lang.String footer()
ExcelML footer
public static java.lang.String sheetHeader(java.lang.String label)
ExcelML sheet header
label
- Sheet labelpublic static java.lang.String sheetHeader(java.lang.String label, int[] colWidths)
ExcelML sheet header
label
- Sheet labelcolWidths
- Columns widthspublic static java.lang.String sheetFooter()
ExcelML sheet footer
public static java.lang.String col(int width)
ExcelML column declaration
width
- Column widthpublic static java.lang.String cols(java.util.Vector<java.lang.Integer> widths)
ExcelML columns declaration
widths
- Colums widthspublic static java.lang.String cols(int[] widths)
ExcelML columns declaration
widths
- Colums widthspublic static java.lang.String row(java.lang.String cells)
ExcelML row
public static java.lang.String cell(ObjectField f, java.lang.String value)
public static java.lang.String cell(double d)
ExcelML number cell for double
d
- Double valuepublic static java.lang.String cell(int i)
ExcelML number cell for integer
i
- Integer valuepublic static java.lang.String cell(long l)
ExcelML number cell for long integer
l
- Long integer valuepublic static java.lang.String cell(java.lang.String t, boolean head)
ExcelML text cell
t
- Texthead
- Header style ?public static java.lang.String cell(java.lang.String t)
ExcelML text cell
@Deprecated public static java.lang.String cell(java.lang.String value, java.lang.String type, boolean head)
public static java.lang.String cell(java.lang.String value, java.lang.String type, java.lang.String style)
ExcelML cell
value
- Cell valuetype
- Cell type (CELL_TYPE_*)style
- Cell style (CELL_STYLE_*)public static java.lang.String formulaCell(java.lang.String formula)
ExcelML formula cell
Formula syntax is a combination of mathematical operators and/or Excel functions (in uppercase english) applied to relative cells or relative cell areas using R/C syntax
Examples : (R[-2]C+R[-1]C)/RC[1]
SUM(R[-3]C:R[-1]C)
formula
- Formulapublic static java.lang.String formulaCell(java.lang.String formula, java.lang.String style)
ExcelML formula cell
Formula syntax is a combination of mathematical operators and/or Excel functions (in uppercase english) applied to relative cells or relative cell areas using R/C syntax
Examples : (R[-2]C+R[-1]C)/RC[1]
SUM(R[-3]C:R[-1]C)
formula
- Formulastyle
- Cell style (CELL_STYLE_*)Copyright (c)2006-2014 Simplicite Software. All Rights Reserved.