public class ExcelGenerator
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
class |
ExcelGenerator.CellDefine |
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
LABEL_FOOTER |
static java.lang.String |
LABEL_HEADER |
static java.lang.String |
LABEL_START_ROW |
Constructor and Description |
---|
ExcelGenerator(net.sf.json.JSONObject opt) |
Modifier and Type | Method and Description |
---|---|
ExcelGenerator.CellDefine |
getCellInstance(java.lang.String position,
java.lang.String fieldId,
java.lang.String fieldName,
java.lang.String label,
int width) |
ExcelGenerator.CellDefine |
getInstance() |
int |
outputFile(java.lang.String fileName)
文件名必须是全路径
|
int |
outputStream(java.io.OutputStream out)
将Excel内容以二进制输出到out中,默认以office2007的方式输出,如果需要2003格式,请调用参数或文件带扩展名
|
int |
outputStream(java.io.OutputStream out,
boolean blOffice2007)
将Excel内容以二进制输出到out中
|
void |
setDataList(java.util.List<java.util.Map> dataList)
设置数据结果集
|
void |
setStyles(java.util.List<ExcelGenerator.CellDefine> cellStyles,
java.lang.String sheetName)
设置输出的样式格式,formats的格式内容为{$fieldName:}
|
void |
setTotalRow(java.util.Map<java.lang.String,java.lang.Object> totalMap)
设置是否有行统计
|
public static final java.lang.String LABEL_HEADER
public static final java.lang.String LABEL_START_ROW
public static final java.lang.String LABEL_FOOTER
public int outputFile(java.lang.String fileName)
fileName
- as Stringpublic int outputStream(java.io.OutputStream out)
out
- as OutputStreamint
- public int outputStream(java.io.OutputStream out, boolean blOffice2007)
out
- as OutputStreamblOffice2007
- as booleanpublic ExcelGenerator.CellDefine getInstance()
public ExcelGenerator.CellDefine getCellInstance(java.lang.String position, java.lang.String fieldId, java.lang.String fieldName, java.lang.String label, int width)
position
- as StringfieldId
- //字段IDfieldName
- //字段名label
- //字段中文标签名width
- 显示列宽度public void setStyles(java.util.List<ExcelGenerator.CellDefine> cellStyles, java.lang.String sheetName)
formats
- as List<Cell>title
- as Stringpublic void setDataList(java.util.List<java.util.Map> dataList)
dataList
- public void setTotalRow(java.util.Map<java.lang.String,java.lang.Object> totalMap)
sumfields
- Copyright © 2019 by Sucang.cn