com.sh.module.page.util

类 PageExportUtil

java.lang.Object

com.sh.module.page.util.PageExportUtil

public class PageExportUtil
extends java.lang.Object

Description: 导出

Title:首亨软件 - TSS/CRM等

从以下版本开始:

Aug 24, 2012

版本:

3.0

作者:

江兴春

构造器概要

构造器

构造器和说明
PageExportUtil()

方法概要

限定符和类型	方法和说明
static java.lang.String	convertHeadLabelFormat(java.lang.String label) 格式化表头换行符为导出文件需要的格式
static void	createCell(java.lang.String label, jxl.write.WritableSheet sheet, int col, int row, TableCell tableCell, jxl.format.CellFormat format) 创建单元格,目前只用字符弄单元格
static java.lang.Object[]	createSheet(int rows, jxl.write.WritableWorkbook book) 创建sheet
static void	exportTable(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, Table table, Page page, PageContext pc) 导出Excel
static void	processExportDs(Datastore ds, javax.servlet.http.HttpServletRequest request, Table table, ListTableInfo listTable, java.util.List<TableCell> cellList, Page page, PageContext pc, PageTableExportCache ptCache) 导出工具
static int	renderHead(Table table, ListTableInfo listTable, jxl.write.WritableSheet sheet, PageContext pc) 渲染表头

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

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

构造器详细资料

PageExportUtil

public PageExportUtil()

方法详细资料

exportTable

public static void exportTable(javax.servlet.http.HttpServletRequest request,
                               javax.servlet.http.HttpServletResponse response,
                               Table table,
                               Page page,
                               PageContext pc)

导出Excel

参数:

request - HttpServletRequest

response - HttpServletResponse

table - Table

page - Page

pc - PageContext

renderHead

public static int renderHead(Table table,
                             ListTableInfo listTable,
                             jxl.write.WritableSheet sheet,
                             PageContext pc)
                      throws jxl.write.biff.RowsExceededException,
                             jxl.write.WriteException

渲染表头

参数:

table - Table

listTable - ListTableInfo

sheet - WritableSheet

pc - PageContext

返回:

int

抛出:

jxl.write.WriteException - WriteException

jxl.write.biff.RowsExceededException - RowsExceededException

convertHeadLabelFormat

public static java.lang.String convertHeadLabelFormat(java.lang.String label)

格式化表头换行符为导出文件需要的格式

参数:

label - String

返回:

String

processExportDs

public static void processExportDs(Datastore ds,
                                   javax.servlet.http.HttpServletRequest request,
                                   Table table,
                                   ListTableInfo listTable,
                                   java.util.List<TableCell> cellList,
                                   Page page,
                                   PageContext pc,
                                   PageTableExportCache ptCache)
                            throws jxl.write.WriteException

导出工具

参数:

ds - 数据集

request - HttpServletRequest

table - Table

listTable - ListTableInfo

cellList - TableCell

page - Page

pc - PageContext

ptCache - PageTableExportCache

抛出:

jxl.write.WriteException - 异常

createSheet

public static java.lang.Object[] createSheet(int rows,
                                             jxl.write.WritableWorkbook book)
                                      throws jxl.write.WriteException

创建sheet

参数:

rows - int

book - WritableWorkbook

返回:

Object

抛出:

jxl.write.WriteException - WriteException

createCell

public static void createCell(java.lang.String label,
                              jxl.write.WritableSheet sheet,
                              int col,
                              int row,
                              TableCell tableCell,
                              jxl.format.CellFormat format)
                       throws jxl.write.biff.RowsExceededException,
                              jxl.write.WriteException

创建单元格,目前只用字符弄单元格

参数:

label - String

sheet - WritableSheet

col - 列号

row - 行号

tableCell - TableCell

format - CellFormat

抛出:

jxl.write.WriteException - WriteException

jxl.write.biff.RowsExceededException - RowsExceededException

jxl.write.biff.RowsExceededException - RowsExceededException

jxl.write.WriteException - WriteException