com.facecto.code.excel

类 ExcelWrite

java.lang.Object

com.facecto.code.excel.ExcelWrite

public class ExcelWrite
extends Object

版本:

v1.0.0 (2021/11/25)

作者:

Jon So, https://cto.pub, https://github.com/facecto

构造器概要

构造器

构造器和说明
ExcelWrite()

方法概要

限定符和类型	方法和说明
private void	excelWriterWithTemplate(Object headData, Object contentData, MergeStrategy mergeStrategy, com.alibaba.excel.write.style.HorizontalCellStyleStrategy horizontalCellStyleStrategy, String outFileName, String templateFileName, boolean hasWeb, javax.servlet.http.HttpServletResponse response, InputStream inputStream)
private String	formatFileName(String filename)
private <X,Y> ByteArrayInputStream	getByteArrayInputStream(ExcelData<X,Y> excelData, org.apache.poi.xssf.usermodel.XSSFWorkbook xssfWorkbook)
private com.alibaba.excel.write.style.HorizontalCellStyleStrategy	getDefaultHorizontalCellStyleStrategy(ExcelStyle style)
private javax.servlet.http.HttpServletResponse	setResponse(String outFileName, javax.servlet.http.HttpServletResponse response)
private <X,Y> void	writeExcelSheet(ExcelData<X,Y> excelData, com.alibaba.excel.ExcelWriter excelWriter)
void	writeWithTemplate(Object headData, Object contentData, MergeStrategy mergeStrategy, com.alibaba.excel.write.style.HorizontalCellStyleStrategy horizontalCellStyleStrategy, String outFileName, String templateFileName) Use the template output excel, you can customize the merging rules and content display style.
void	writeWithTemplateByWeb(Object headData, Object contentData, MergeStrategy mergeStrategy, com.alibaba.excel.write.style.HorizontalCellStyleStrategy horizontalCellStyleStrategy, String outFileName, String templateFileName, javax.servlet.http.HttpServletResponse response) Use the template output excel by web, you can customize the merging rules and content display style.
<X,Y> void	writeWithTemplateMultiSheet(ExcelData<X,Y> excelData, String outFileName, String templateFileName) Use templates to write multi-sheet files: containing table headers, multiple rows of content.
<X,Y> void	writeWithTemplateMultiSheetByWeb(ExcelData<X,Y> excelData, String outFileName, String templateFileName, javax.servlet.http.HttpServletResponse response) Use templates to write multi-sheet files by web: containing table headers, multiple rows of content.

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

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

构造器详细资料

ExcelWrite

public ExcelWrite()

方法详细资料

writeWithTemplateByWeb

public void writeWithTemplateByWeb(Object headData,
                                   Object contentData,
                                   MergeStrategy mergeStrategy,
                                   com.alibaba.excel.write.style.HorizontalCellStyleStrategy horizontalCellStyleStrategy,
                                   String outFileName,
                                   String templateFileName,
                                   javax.servlet.http.HttpServletResponse response)
                            throws IOException

Use the template output excel by web, you can customize the merging rules and content display style.

参数:

headData - Excel header section

contentData - Excel content section

mergeStrategy - Merge styles

horizontalCellStyleStrategy - Content styles

outFileName - Output file name

templateFileName - Template file name

response - response

抛出:

IOException

writeWithTemplate

public void writeWithTemplate(Object headData,
                              Object contentData,
                              MergeStrategy mergeStrategy,
                              com.alibaba.excel.write.style.HorizontalCellStyleStrategy horizontalCellStyleStrategy,
                              String outFileName,
                              String templateFileName)
                       throws IOException

Use the template output excel, you can customize the merging rules and content display style.

参数:

headData - Excel header section

contentData - Excel content section

mergeStrategy - Merge styles

horizontalCellStyleStrategy - Content styles

outFileName - Output file name

templateFileName - Template file name

抛出:

IOException

writeWithTemplateMultiSheetByWeb

public <X,Y> void writeWithTemplateMultiSheetByWeb(ExcelData<X,Y> excelData,
                                                   String outFileName,
                                                   String templateFileName,
                                                   javax.servlet.http.HttpServletResponse response)
                                            throws IOException

Use templates to write multi-sheet files by web: containing table headers, multiple rows of content.

类型参数:

X - Sheet header data type

Y - Sheet body data type

参数:

excelData - Sheet header, sheet content, sheet name

outFileName - File name

templateFileName - Template file name

response - HttpServletResponse

抛出:

IOException

writeWithTemplateMultiSheet

public <X,Y> void writeWithTemplateMultiSheet(ExcelData<X,Y> excelData,
                                              String outFileName,
                                              String templateFileName)
                                       throws IOException

Use templates to write multi-sheet files: containing table headers, multiple rows of content.

类型参数:

X - Sheet header data type

Y - Sheet body data type

参数:

excelData - Sheet header, sheet content, sheet name

outFileName - File name ,full path. example: /home/out.xlsx

templateFileName - Template name, full path. example: /home/template.xlsx

抛出:

IOException

getByteArrayInputStream

private <X,Y> ByteArrayInputStream getByteArrayInputStream(ExcelData<X,Y> excelData,
                                                           org.apache.poi.xssf.usermodel.XSSFWorkbook xssfWorkbook)
                                                    throws IOException

抛出:

IOException

writeExcelSheet

private <X,Y> void writeExcelSheet(ExcelData<X,Y> excelData,
                                   com.alibaba.excel.ExcelWriter excelWriter)

setResponse

private javax.servlet.http.HttpServletResponse setResponse(String outFileName,
                                                           javax.servlet.http.HttpServletResponse response)

excelWriterWithTemplate

private void excelWriterWithTemplate(Object headData,
                                     Object contentData,
                                     MergeStrategy mergeStrategy,
                                     com.alibaba.excel.write.style.HorizontalCellStyleStrategy horizontalCellStyleStrategy,
                                     String outFileName,
                                     String templateFileName,
                                     boolean hasWeb,
                                     javax.servlet.http.HttpServletResponse response,
                                     InputStream inputStream)
                              throws IOException

抛出:

IOException

getDefaultHorizontalCellStyleStrategy

private com.alibaba.excel.write.style.HorizontalCellStyleStrategy getDefaultHorizontalCellStyleStrategy(ExcelStyle style)

formatFileName

private String formatFileName(String filename)