com.sh.common.util

类 ExcelExport

java.lang.Object

com.sh.common.util.ExportBase

com.sh.common.util.ExcelExport

public class ExcelExport
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

构造器概要

构造器

构造器和说明
ExcelExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(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)
ExcelExport(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)
ExcelExport(DataCenter dc, java.io.File file, java.lang.String sql, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[][] excelTitle, java.lang.String[] excelCols) 构造函数
ExcelExport(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) 构造函数
ExcelExport(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) 构造函数
ExcelExport(DataCenter dc, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String sql, java.lang.String[] excelTitle, java.lang.String[] excelCols) 构造函数
ExcelExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(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)
ExcelExport(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)
ExcelExport(DataCenter dc, java.io.OutputStream outputStream, java.lang.String sql, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.File file, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.File file, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.File file, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.File file, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(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)
ExcelExport(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)
ExcelExport(Datastore ds, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[][] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] colsType, java.lang.Object[] obj, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(Datastore ds, java.io.OutputStream outputStream, java.lang.String[] excelTitle, java.lang.String[] excelCols)
ExcelExport(javax.servlet.http.HttpServletResponse response)
ExcelExport(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(CellStyle style) 设置单元格样式
void	setCharset(java.lang.String charset) 设置编码
void	setColumnWidth(int col, int width) 设置宽度
void	setHeadCellStyle(HeaderCellStyle style) 设置表头样式
void	setNotifyBodyEvent(EventListener evtListener) 已过时。
void	setNotifyHeadEvent(EventListener evtListener) 已过时。
void	setRowHeight(int row, int height)

从类继承的方法 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

构造器详细资料

ExcelExport

public ExcelExport(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

ExcelExport

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

ExcelExport

public ExcelExport(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中的列名

ExcelExport

public ExcelExport(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

ExcelExport

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

ExcelExport

public ExcelExport(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中的列名

ExcelExport

public ExcelExport(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

ExcelExport

public ExcelExport(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)

ExcelExport

public ExcelExport(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中的列名

ExcelExport

public ExcelExport(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

ExcelExport

public ExcelExport(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)

ExcelExport

public ExcelExport(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中的列名

ExcelExport

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

抛出:

java.lang.Exception

ExcelExport

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

ExcelExport

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

ExcelExport

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

抛出:

java.lang.Exception

ExcelExport

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

ExcelExport

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

ExcelExport

public ExcelExport(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

ExcelExport

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

ExcelExport

public ExcelExport(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)

ExcelExport

public ExcelExport(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

ExcelExport

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

ExcelExport

public ExcelExport(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)

ExcelExport

public ExcelExport(java.io.OutputStream outputStream)

ExcelExport

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

方法详细资料

setNotifyHeadEvent

public void setNotifyHeadEvent(EventListener evtListener)

已过时。

是否设置表头事件

参数:

evtListener - EventListener

setNotifyBodyEvent

public void setNotifyBodyEvent(EventListener evtListener)

已过时。

是否设置表体事件

参数:

evtListener - EventListener

setCharset

public void setCharset(java.lang.String charset)

设置编码

参数:

charset - String

setColumnWidth

public void setColumnWidth(int col,
                           int width)

设置宽度

参数:

col - 列号 从0开始

width - 宽度

setRowHeight

public void setRowHeight(int row,
                         int height)

createSheet

public void createSheet(int rows)
                 throws jxl.write.WriteException

创建sheet

参数:

rows - int

抛出:

jxl.write.WriteException - WriteException

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

setCellStyle

public void setCellStyle(CellStyle style)

设置单元格样式

参数:

style - CellStyle

setHeadCellStyle

public void setHeadCellStyle(HeaderCellStyle style)

设置表头样式

参数:

style - HeaderCellStyle

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

addCell

public void addCell(ExcelCell cell)