com.sh.common.util

类 ExcelBigExport

java.lang.Object

com.sh.common.util.ExportBase

com.sh.common.util.ExcelBigExport

public class ExcelBigExport
extends ExportBase

Description: Excel文件处理工具类,分页导出，防止内存溢出,同时导出速度较慢

Title:首亨软件

Company：首亨软件(重庆)有限公司

版本:

1.0

作者:

江兴春 Date: Dec 8, 2009

字段概要

字段

限定符和类型	字段和说明
static int	EXPORT_PAGE_ROWS

从类继承的字段 com.sh.common.util.ExportBase

CHARSET_GBK, CHARSET_ISSO_8859_1, CHARSET_UTF_8, DEFAULT_CHARSET, ENABLE_DOWNLOAD_MAX_NUM, FTNEXS_DIR, SHEET_MAX_ROW, TO_FTNEXS_FILES, TO_FTNEXS_TASK

构造器概要

构造器

构造器和说明
ExcelBigExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[][] excelTitle, java.lang.String[] excelCols) 构造函数
ExcelBigExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols) 构造函数
ExcelBigExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols) 构造函数
ExcelBigExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] excelTitle, java.lang.String[] excelCols) 构造函数
ExcelBigExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.File file, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.File file, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.File file, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.File file, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelBigExport(javax.servlet.http.HttpServletResponse response)
ExcelBigExport(java.io.OutputStream outputStream)

方法概要

限定符和类型	方法和说明
void	addCell(ExcelCell cell)
void	addWebCharts(WebChartsCell webChart) 添加图片
void	createSheet(int rows) 创建sheet
void	doExport()
void	doExport(java.lang.String fileName) 执行导出操作
DataCenter	getDc()
void	mergeHeaderCells(ExcelMerge mergeCell) 合并表头单元格
void	mergeHeaderCells(int col1, int row1, int col2, int row2) 设置合并单元格
void	setCellStyle(ExcelBigCellStyle style) 设置单元格样式
void	setCharset(java.lang.String charset) 设置编码
void	setColumnWidth(int col, int width) 设置宽度

从类继承的方法 com.sh.common.util.ExportBase

getRefreshDsObj, refreshDs, refreshDs, setRefreshDs

从类继承的方法 java.lang.Object

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

字段详细资料

EXPORT_PAGE_ROWS

public static int EXPORT_PAGE_ROWS

构造器详细资料

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.File file,
                      java.lang.String sql,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.OutputStream outputStream,
                      java.lang.String sql,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String sql,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

excelTitle - EXCEL中标题行

excelCols - 每列对应DS中的列名

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.File file,
                      java.lang.String sql,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.OutputStream outputStream,
                      java.lang.String sql,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String sql,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

excelTitle - EXCEL中标题行

excelCols - 每列对应DS中的列名

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.File file,
                      java.lang.String sql,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.OutputStream outputStream,
                      java.lang.String sql,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String sql,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

colsType - 查询参数类型

obj - 查询参数

excelTitle - EXCEL中标题行

excelCols - 每列对应DS中的列名

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.File file,
                      java.lang.String sql,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      java.io.OutputStream outputStream,
                      java.lang.String sql,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(DataCenter dc,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String sql,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

构造函数

参数:

dc - 数据中心

request - HttpServletRequest

response - HttpServletResponse

sql - 导出SQL

colsType - 查询参数类型

obj - 查询参数

excelTitle - EXCEL中标题行

excelCols - 每列对应DS中的列名

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.File file,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.OutputStream outputStream,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.File file,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.OutputStream outputStream,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.File file,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.OutputStream outputStream,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.File file,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)
               throws java.lang.Exception

抛出:

java.lang.Exception

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      java.io.OutputStream outputStream,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(Datastore ds,
                      javax.servlet.http.HttpServletRequest request,
                      javax.servlet.http.HttpServletResponse response,
                      java.lang.String[] colsType,
                      java.lang.Object[] obj,
                      java.lang.String[][] excelTitle,
                      java.lang.String[] excelCols)

ExcelBigExport

public ExcelBigExport(java.io.OutputStream outputStream)

ExcelBigExport

public ExcelBigExport(javax.servlet.http.HttpServletResponse response)

方法详细资料

setCharset

public void setCharset(java.lang.String charset)

设置编码

参数:

charset - String

setColumnWidth

public void setColumnWidth(int col,
                           int width)

设置宽度

参数:

col - 列号 从0开始

width - 宽度

createSheet

public void createSheet(int rows)

创建sheet

参数:

rows - int

doExport

public void doExport()
              throws java.lang.Exception

抛出:

java.lang.Exception

doExport

public void doExport(java.lang.String fileName)
              throws java.lang.Exception

执行导出操作

参数:

fileName - 导出文件名

抛出:

java.lang.Exception - Exception

mergeHeaderCells

public void mergeHeaderCells(ExcelMerge mergeCell)

合并表头单元格

参数:

mergeCell - ExcelMerge

mergeHeaderCells

public void mergeHeaderCells(int col1,
                             int row1,
                             int col2,
                             int row2)

设置合并单元格

参数:

col1 - 起始单元格列号

row1 - 起始单元格行号

col2 - 结束单元格列号

row2 - 结束单元格行号

getDc

public DataCenter getDc()

addWebCharts

public void addWebCharts(WebChartsCell webChart)

添加图片

参数:

webChart - WebChartsCell

setCellStyle

public void setCellStyle(ExcelBigCellStyle style)

设置单元格样式

参数:

style - ExcelBigCellStyle

addCell

public void addCell(ExcelCell cell)