com.fr.write.web.excel

类 WebExcelUtils

java.lang.Object

com.fr.write.web.excel.WebExcelUtils

public class WebExcelUtils
extends java.lang.Object

嵌套类概要

嵌套类

限定符和类型	类和说明
static class	WebExcelUtils.ExcelUploadException

构造器概要

构造器

构造器和说明
WebExcelUtils()

方法概要

方法

限定符和类型	方法和说明
static void	cacheTMPExcel(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res, java.lang.String key) 缓存上传的excel文件,自定义设置的时候需要不断拿文件来进行交互
static TemplateWorkBook	customizedDealWithUploadExcel(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res, java.util.Map<java.lang.String,java.lang.Object> paraMap) 把上传的excel转成模板(自定义)
static TemplateWorkBook	dealWithUploadExcel(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res) 把上传的excel转成模板
static TemplateWorkBook	dealWithUploadExcel(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res, java.util.Map<java.lang.String,java.lang.Object> paraMap) 把上传的excel转成模板
static JSONObject	getExcelConfigBySheet(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res, java.lang.String sessionID, int sheetIndex) 生成自定义导入excel相关配置信息
static SmartFile	getExcelFromReq(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res)
static java.lang.String[]	getSheetsName(java.lang.String sessionID)

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

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

构造器详细资料

WebExcelUtils

public WebExcelUtils()

方法详细资料

getExcelConfigBySheet

public static JSONObject getExcelConfigBySheet(javax.servlet.http.HttpServletRequest req,
                               javax.servlet.http.HttpServletResponse res,
                               java.lang.String sessionID,
                               int sheetIndex)
                                        throws java.lang.Exception

生成自定义导入excel相关配置信息

参数:

req -

res -

sessionID -

sheetIndex - sheet索引

返回:

抛出:

java.lang.Exception

getSheetsName

public static java.lang.String[] getSheetsName(java.lang.String sessionID)

getExcelFromReq

public static SmartFile getExcelFromReq(javax.servlet.http.HttpServletRequest req,
                        javax.servlet.http.HttpServletResponse res)
                                 throws java.lang.Exception

抛出:

java.lang.Exception

dealWithUploadExcel

public static TemplateWorkBook dealWithUploadExcel(javax.servlet.http.HttpServletRequest req,
                                   javax.servlet.http.HttpServletResponse res,
                                   java.util.Map<java.lang.String,java.lang.Object> paraMap)
                                            throws java.lang.Exception

把上传的excel转成模板

参数:

req - http请求

res - http应答

paraMap - 参数

返回:

模板

抛出:

java.lang.Exception

customizedDealWithUploadExcel

public static TemplateWorkBook customizedDealWithUploadExcel(javax.servlet.http.HttpServletRequest req,
                                             javax.servlet.http.HttpServletResponse res,
                                             java.util.Map<java.lang.String,java.lang.Object> paraMap)
                                                      throws java.lang.Exception

把上传的excel转成模板(自定义)

参数:

req - http请求

res - http应答

paraMap - 参数

返回:

模板

抛出:

java.lang.Exception

dealWithUploadExcel

public static TemplateWorkBook dealWithUploadExcel(javax.servlet.http.HttpServletRequest req,
                                   javax.servlet.http.HttpServletResponse res)
                                            throws java.lang.Exception

把上传的excel转成模板

参数:

req - http请求

res - http应答

返回:

模板

抛出:

java.lang.Exception

cacheTMPExcel

public static void cacheTMPExcel(javax.servlet.http.HttpServletRequest req,
                 javax.servlet.http.HttpServletResponse res,
                 java.lang.String key)
                          throws java.lang.Exception

缓存上传的excel文件,自定义设置的时候需要不断拿文件来进行交互

参数:

req -

res -

key -

抛出:

java.lang.Exception