com.alanpoi.analysis.common.utils

类 ExcelExportUtil

java.lang.Object

com.alanpoi.analysis.common.utils.ExcelExportUtil

public class ExcelExportUtil
extends Object

Excel Export Util

从以下版本开始:

2020-3-18

作者:

pengzhuoxun

字段概要

字段

限定符和类型	字段和说明
protected static org.slf4j.Logger	logger

构造器概要

构造器

构造器和说明
ExcelExportUtil()

方法概要

限定符和类型	方法和说明
static void	export(Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
static void	export(Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String fileName) Export Excel to the browser
static void	export(ExcelType excelType, Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String fileName)
static void	exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
static void	exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap, String fileName, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) Export multiple sheet tab Excel to the browser
static void	exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap, String fileName, Map<Integer,List<String>> specifyCol, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) Export multiple sheet tab Excel to the browser, allowing you to specify the columns to be exported
static void	exportSpecifyCol(ExcelType excelType, Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String fileName, List<String> specifyCol) Export Excel to the browser, allowing you to specify the columns to be exported
static org.apache.poi.ss.usermodel.Workbook	getWorkbook(Collection<?> singleSheetData, Class<?> c) get excel workbook object
static org.apache.poi.ss.usermodel.Workbook	getWorkbook(ExcelType excelType, Collection<?> singleSheetData, Class<?> c)
static org.apache.poi.ss.usermodel.Workbook	getWorkbookByMultiSheet(ExcelType excelType, Map<Class<?>,Collection<?>> dataMap) Get Multi sheet workbook object
static org.apache.poi.ss.usermodel.Workbook	getWorkbookByMultiSheet(Map<Class<?>,Collection<?>> dataMap)
static org.apache.poi.ss.usermodel.Workbook	getWorkbookSpecifyCol(Collection<?> singleSheetData, Class<?> c, List<String> specifyCol) Gets the workbook object of the specified column

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

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

字段详细资料

logger

protected static final org.slf4j.Logger logger

构造器详细资料

ExcelExportUtil

public ExcelExportUtil()

方法详细资料

getWorkbook

public static org.apache.poi.ss.usermodel.Workbook getWorkbook(Collection<?> singleSheetData,
                                                               Class<?> c)

get excel workbook object

参数:

singleSheetData -

c -

返回:

getWorkbook

public static org.apache.poi.ss.usermodel.Workbook getWorkbook(ExcelType excelType,
                                                               Collection<?> singleSheetData,
                                                               Class<?> c)

getWorkbookSpecifyCol

public static org.apache.poi.ss.usermodel.Workbook getWorkbookSpecifyCol(Collection<?> singleSheetData,
                                                                         Class<?> c,
                                                                         List<String> specifyCol)

Gets the workbook object of the specified column

参数:

singleSheetData -

c -

specifyCol -

返回:

getWorkbookByMultiSheet

public static org.apache.poi.ss.usermodel.Workbook getWorkbookByMultiSheet(ExcelType excelType,
                                                                           Map<Class<?>,Collection<?>> dataMap)

Get Multi sheet workbook object

参数:

excelType -

dataMap -

返回:

Workbook

getWorkbookByMultiSheet

public static org.apache.poi.ss.usermodel.Workbook getWorkbookByMultiSheet(Map<Class<?>,Collection<?>> dataMap)

export

public static void export(ExcelType excelType,
                          Collection<?> singleSheetData,
                          Class<?> c,
                          javax.servlet.http.HttpServletRequest request,
                          javax.servlet.http.HttpServletResponse response,
                          String fileName)

exportSpecifyCol

public static void exportSpecifyCol(ExcelType excelType,
                                    Collection<?> singleSheetData,
                                    Class<?> c,
                                    javax.servlet.http.HttpServletRequest request,
                                    javax.servlet.http.HttpServletResponse response,
                                    String fileName,
                                    List<String> specifyCol)

Export Excel to the browser, allowing you to specify the columns to be exported

参数:

excelType -

singleSheetData -

c -

request -

response -

fileName -

specifyCol -

export

public static void export(Collection<?> singleSheetData,
                          Class<?> c,
                          javax.servlet.http.HttpServletRequest request,
                          javax.servlet.http.HttpServletResponse response,
                          String fileName)

Export Excel to the browser

参数:

singleSheetData -

c -

request -

response -

fileName -

export

public static void export(Collection<?> singleSheetData,
                          Class<?> c,
                          javax.servlet.http.HttpServletRequest request,
                          javax.servlet.http.HttpServletResponse response)

exportByMultiSheet

public static void exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap,
                                      javax.servlet.http.HttpServletRequest request,
                                      javax.servlet.http.HttpServletResponse response)

exportByMultiSheet

public static void exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap,
                                      String fileName,
                                      javax.servlet.http.HttpServletRequest request,
                                      javax.servlet.http.HttpServletResponse response)

Export multiple sheet tab Excel to the browser

参数:

dataMap -

fileName -

request -

response -

exportByMultiSheet

public static void exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap,
                                      String fileName,
                                      Map<Integer,List<String>> specifyCol,
                                      javax.servlet.http.HttpServletRequest request,
                                      javax.servlet.http.HttpServletResponse response)

Export multiple sheet tab Excel to the browser, allowing you to specify the columns to be exported

参数:

dataMap -

fileName -

request -

response -