程序包 com.sh.common.excel

类 ExportHelper

java.lang.Object

com.sh.common.util.ExportBase

com.sh.common.excel.ExportHelper

public class ExportHelper
extends ExportBase

Description: Excel导出类 Title:首亨软件 - CRM、TSS、ERP等信息化管理软件

字段概要

字段

修饰符和类型	字段	说明
static final String	DEFAULT_LINE_END

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

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

构造器概要

构造器

构造器	说明
ExportHelper()
ExportHelper(jakarta.servlet.http.HttpServletResponse response, String exportName)
ExportHelper(String exportName)

方法概要

修饰符和类型	方法	说明
void	addStyle(String styleStr)	添加Excel样式
void	beforeCreateHeader(String str)	在创建表头前添加代码，如： <Column ss:Width="51" ss:Span="1"/> <Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="528.75"/>
void	doExport(DataCenter dc, String sql, ExcelCell[] cells)
void	doExport(DataCenter dc, String sql, String[] colsType, Object[] obj, ExcelCell[] cells)
void	doExport(DataCenter dc, String sql, String[] colsType, Object[] obj, ExcelCell[] cells, String charset)	Excel导出
void	exportTask(DataCenter dc, String sql, ExcelCell[] cells, File file)
void	exportTask(DataCenter dc, String sql, String[] colsType, Object[] obj, ExcelCell[] cells, File file)	Excel导出,后台自动转向时调用
void	setExportName(String exportName)
void	setSelfHeader(String selfHeader, int rowCount)	设置自定义表头

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

getRefreshDsObj, refreshDs, refreshDs, setRefreshDs

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

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

字段详细资料

DEFAULT_LINE_END

public static final String DEFAULT_LINE_END

另请参阅:

• 常量字段值

构造器详细资料

ExportHelper

public ExportHelper()

ExportHelper

public ExportHelper(String exportName)

ExportHelper

public ExportHelper(jakarta.servlet.http.HttpServletResponse response,
 String exportName)

方法详细资料

setSelfHeader

public void setSelfHeader(String selfHeader,
 int rowCount)

设置自定义表头

参数:

selfHeader - String

rowCount - int

addStyle

public void addStyle(String styleStr)

添加Excel样式

参数:

styleStr - String

beforeCreateHeader

public void beforeCreateHeader(String str)

在创建表头前添加代码，如： <Column ss:Width="51" ss:Span="1"/> <Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="528.75"/>

参数:

str - String

setExportName

public void setExportName(String exportName)

doExport

public void doExport(DataCenter dc,
 String sql,
 ExcelCell[] cells)

doExport

public void doExport(DataCenter dc,
 String sql,
 String[] colsType,
 Object[] obj,
 ExcelCell[] cells)

doExport

public void doExport(DataCenter dc,
 String sql,
 String[] colsType,
 Object[] obj,
 ExcelCell[] cells,
 String charset)

Excel导出

参数:

dc - DataCenter

sql - String

colsType - String[]

obj - Object[]

cells - ExcelCell[]

charset - String

exportTask

public void exportTask(DataCenter dc,
 String sql,
 ExcelCell[] cells,
 File file)

exportTask

public void exportTask(DataCenter dc,
 String sql,
 String[] colsType,
 Object[] obj,
 ExcelCell[] cells,
 File file)

Excel导出,后台自动转向时调用

参数:

dc - DataCenter

sql - String

colsType - String[]

obj - Object[]

cells - ExcelCell[]

file - File