public class ExcelExportUtil extends Object
限定符和类型 | 字段和说明 |
---|---|
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
|
public static org.apache.poi.ss.usermodel.Workbook getWorkbook(Collection<?> singleSheetData, Class<?> c)
singleSheetData
- c
- public static org.apache.poi.ss.usermodel.Workbook getWorkbook(ExcelType excelType, Collection<?> singleSheetData, Class<?> c)
public static org.apache.poi.ss.usermodel.Workbook getWorkbookSpecifyCol(Collection<?> singleSheetData, Class<?> c, List<String> specifyCol)
singleSheetData
- c
- specifyCol
- public static org.apache.poi.ss.usermodel.Workbook getWorkbookByMultiSheet(ExcelType excelType, Map<Class<?>,Collection<?>> dataMap)
excelType
- dataMap
- public static org.apache.poi.ss.usermodel.Workbook getWorkbookByMultiSheet(Map<Class<?>,Collection<?>> dataMap)
public static void export(ExcelType excelType, Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String fileName)
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)
excelType
- singleSheetData
- c
- request
- response
- fileName
- specifyCol
- public static void export(Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String fileName)
singleSheetData
- c
- request
- response
- fileName
- public static void export(Collection<?> singleSheetData, Class<?> c, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
public static void exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
public static void exportByMultiSheet(Map<Class<?>,Collection<?>> dataMap, String fileName, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
dataMap
- fileName
- request
- response
- 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)
dataMap
- fileName
- request
- response
- Copyright © 2021. All rights reserved.