com.eworkcloud.web.util

类 ExcelUtils

java.lang.Object

com.eworkcloud.web.util.ExcelUtils

public abstract class ExcelUtils
extends Object

Excel 导入|导出|下载

作者:

马恩全

构造器概要

构造器

构造器和说明
ExcelUtils()

方法概要

限定符和类型	方法和说明
static <T> void	attachSheet(org.apache.poi.ss.usermodel.Workbook workbook, Collection<T> dataSet, Class<T> clazz) 导出Excel
static <T> void	attachSheet(org.apache.poi.ss.usermodel.Workbook workbook, Collection<T> dataSet, Class<T> clazz, ExportParams params) 导出Excel
static org.apache.poi.ss.usermodel.Workbook	createWorkbook(ExcelType type) 创建EXCEL对象
static org.apache.poi.ss.usermodel.Workbook	createWorkbook(InputStream inputStream) 创建EXCEL对象
static org.apache.poi.ss.usermodel.Workbook	createWorkbook(org.springframework.web.multipart.MultipartFile multipart) 创建EXCEL对象
static void	downLoad(javax.servlet.http.HttpServletResponse response, org.apache.poi.ss.usermodel.Workbook workbook, String filename) 下载Excel
static <T> org.apache.poi.ss.usermodel.Workbook	exportExcel(Collection<T> dataSet, Class<T> clazz) 导出Excel
static <T> org.apache.poi.ss.usermodel.Workbook	exportExcel(Collection<T> dataSet, Class<T> clazz, ExportParams params) 导出Excel
static <T> List<T>	importExcel(InputStream inputStream, Class<T> clazz) 导入Excel
static <T> List<T>	importExcel(InputStream inputStream, Class<T> clazz, ImportParams params) 导入Excel
static <T> List<T>	importExcel(org.springframework.web.multipart.MultipartFile multipart, Class<T> clazz) 导入Excel
static <T> List<T>	importExcel(org.springframework.web.multipart.MultipartFile multipart, Class<T> clazz, ImportParams params) 导入Excel
static <T> List<T>	importExcel(org.apache.poi.ss.usermodel.Workbook workbook, Class<T> clazz, ImportParams params) 导入Excel

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

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

构造器详细资料

ExcelUtils

public ExcelUtils()

方法详细资料

createWorkbook

public static org.apache.poi.ss.usermodel.Workbook createWorkbook(InputStream inputStream)

创建EXCEL对象

参数:

inputStream - InputStream

返回:

EXCEL对象

createWorkbook

public static org.apache.poi.ss.usermodel.Workbook createWorkbook(org.springframework.web.multipart.MultipartFile multipart)

创建EXCEL对象

参数:

multipart - MultipartFile

返回:

EXCEL对象

createWorkbook

public static org.apache.poi.ss.usermodel.Workbook createWorkbook(ExcelType type)

创建EXCEL对象

参数:

type - 类型

返回:

EXCEL对象

importExcel

public static <T> List<T> importExcel(org.apache.poi.ss.usermodel.Workbook workbook,
                                      Class<T> clazz,
                                      ImportParams params)

导入Excel

类型参数:

T - 类型

参数:

workbook - Workbook

clazz - 类

params - 参数

返回:

指定类型列表

importExcel

public static <T> List<T> importExcel(InputStream inputStream,
                                      Class<T> clazz,
                                      ImportParams params)

导入Excel

类型参数:

T - 类型

参数:

inputStream - InputStream

clazz - 类

params - 参数

返回:

指定类型列表

importExcel

public static <T> List<T> importExcel(org.springframework.web.multipart.MultipartFile multipart,
                                      Class<T> clazz,
                                      ImportParams params)

导入Excel

类型参数:

T - 类型

参数:

multipart - MultipartFile

clazz - 类

params - 参数

返回:

指定类型列表

importExcel

public static <T> List<T> importExcel(InputStream inputStream,
                                      Class<T> clazz)

导入Excel

类型参数:

T - 类型

参数:

inputStream - InputStream

clazz - 类

返回:

指定类型列表

importExcel

public static <T> List<T> importExcel(org.springframework.web.multipart.MultipartFile multipart,
                                      Class<T> clazz)

导入Excel

类型参数:

T - 类型

参数:

multipart - MultipartFile

clazz - 类

返回:

指定类型列表

attachSheet

public static <T> void attachSheet(org.apache.poi.ss.usermodel.Workbook workbook,
                                   Collection<T> dataSet,
                                   Class<T> clazz,
                                   ExportParams params)

导出Excel

类型参数:

T - 类型

参数:

workbook - Workbook

dataSet - 数据

clazz - 类

params - 参数

attachSheet

public static <T> void attachSheet(org.apache.poi.ss.usermodel.Workbook workbook,
                                   Collection<T> dataSet,
                                   Class<T> clazz)

导出Excel

类型参数:

T - 类型

参数:

workbook - Workbook

dataSet - 数据

clazz - 类

exportExcel

public static <T> org.apache.poi.ss.usermodel.Workbook exportExcel(Collection<T> dataSet,
                                                                   Class<T> clazz,
                                                                   ExportParams params)

导出Excel

类型参数:

T - 类型

参数:

dataSet - 数据

clazz - 类

params - 参数

返回:

Workbook

exportExcel

public static <T> org.apache.poi.ss.usermodel.Workbook exportExcel(Collection<T> dataSet,
                                                                   Class<T> clazz)

导出Excel

类型参数:

T - 类型

参数:

dataSet - 数据

clazz - 类

返回:

Workbook

downLoad

public static void downLoad(javax.servlet.http.HttpServletResponse response,
                            org.apache.poi.ss.usermodel.Workbook workbook,
                            String filename)

下载Excel

参数:

response - 响应对象

workbook - Excel

filename - 文件名