com.publiccms.common.view

类 ExcelView

java.lang.Object

org.springframework.context.support.ApplicationObjectSupport

org.springframework.web.context.support.WebApplicationObjectSupport

org.springframework.web.servlet.view.AbstractView

org.springframework.web.servlet.view.document.AbstractXlsView

org.springframework.web.servlet.view.document.AbstractXlsxView

org.springframework.web.servlet.view.document.AbstractXlsxStreamingView

com.publiccms.common.view.ExcelView

所有已实现的接口:

org.springframework.beans.factory.Aware, org.springframework.beans.factory.BeanNameAware, org.springframework.context.ApplicationContextAware, org.springframework.web.context.ServletContextAware, org.springframework.web.servlet.View

public class ExcelView
extends org.springframework.web.servlet.view.document.AbstractXlsxStreamingView

字段概要

字段

限定符和类型	字段和说明
private java.util.function.Consumer<org.apache.poi.ss.usermodel.Workbook>	consumer
private java.lang.String	filename
static java.lang.String	SUFFIX

从类继承的字段 org.springframework.web.servlet.view.AbstractView

DEFAULT_CONTENT_TYPE

从类继承的字段 org.springframework.context.support.ApplicationObjectSupport

logger

从接口继承的字段 org.springframework.web.servlet.View

PATH_VARIABLES, RESPONSE_STATUS_ATTRIBUTE, SELECTED_CONTENT_TYPE

构造器概要

构造器

构造器和说明
ExcelView(java.util.function.Consumer<org.apache.poi.ss.usermodel.Workbook> consumer)
ExcelView(java.lang.String filename, java.util.function.Consumer<org.apache.poi.ss.usermodel.Workbook> consumer) @RequestMapping("export") public ExcelView export() { ExcelView view = new ExcelView(workbook -> { Sheet sheet = workbook.createSheet("sheetname"); int i = 0, j = 0; Row row = sheet.createRow(i++); row.createCell(j++).setCellValue("id"); row.createCell(j++).setCellValue("title"); row = sheet.createRow(i++); row.createCell(j++).setCellValue("id"); row.createCell(j++).setCellValue("title"); }); view.setFilename("filename"); return view; }

方法概要

限定符和类型	方法和说明
protected void	buildExcelDocument(java.util.Map<java.lang.String,java.lang.Object> model, org.apache.poi.ss.usermodel.Workbook workbook, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
java.lang.String	getFilename()
void	setFilename(java.lang.String filename)

从类继承的方法 org.springframework.web.servlet.view.document.AbstractXlsxStreamingView

createWorkbook, renderWorkbook

从类继承的方法 org.springframework.web.servlet.view.document.AbstractXlsView

generatesDownloadContent, renderMergedOutputModel

从类继承的方法 org.springframework.web.servlet.view.AbstractView

addStaticAttribute, createMergedOutputModel, createRequestContext, createTemporaryOutputStream, exposeModelAsRequestAttributes, formatViewName, getAttributesMap, getBeanName, getContentType, getRequestContextAttribute, getRequestToExpose, getStaticAttributes, isExposePathVariables, prepareResponse, render, setAttributes, setAttributesCSV, setAttributesMap, setBeanName, setContentType, setExposeContextBeansAsAttributes, setExposedContextBeanNames, setExposePathVariables, setRequestContextAttribute, setResponseContentType, toString, writeToResponse

从类继承的方法 org.springframework.web.context.support.WebApplicationObjectSupport

getServletContext, getTempDir, getWebApplicationContext, initApplicationContext, initServletContext, isContextRequired, setServletContext

从类继承的方法 org.springframework.context.support.ApplicationObjectSupport

getApplicationContext, getMessageSourceAccessor, initApplicationContext, obtainApplicationContext, requiredContextClass, setApplicationContext

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

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

字段详细资料

consumer

private java.util.function.Consumer<org.apache.poi.ss.usermodel.Workbook> consumer

filename

private java.lang.String filename

SUFFIX

public static final java.lang.String SUFFIX

另请参阅:

常量字段值

构造器详细资料

ExcelView

public ExcelView(java.lang.String filename,
                 java.util.function.Consumer<org.apache.poi.ss.usermodel.Workbook> consumer)

 @RequestMapping("export")
 public ExcelView export() {
     ExcelView view = new ExcelView(workbook -> {
         Sheet sheet = workbook.createSheet("sheetname");
         int i = 0, j = 0;
         Row row = sheet.createRow(i++);
         row.createCell(j++).setCellValue("id");
         row.createCell(j++).setCellValue("title");
         row = sheet.createRow(i++);
         row.createCell(j++).setCellValue("id");
         row.createCell(j++).setCellValue("title");
     });
     view.setFilename("filename");
     return view;
 }
 

参数:

filename -

consumer - the consumer to set

ExcelView

public ExcelView(java.util.function.Consumer<org.apache.poi.ss.usermodel.Workbook> consumer)

方法详细资料

buildExcelDocument

protected void buildExcelDocument(java.util.Map<java.lang.String,java.lang.Object> model,
                                  org.apache.poi.ss.usermodel.Workbook workbook,
                                  javax.servlet.http.HttpServletRequest request,
                                  javax.servlet.http.HttpServletResponse response)
                           throws java.lang.Exception

指定者:

buildExcelDocument 在类中 org.springframework.web.servlet.view.document.AbstractXlsView

抛出:

java.lang.Exception

getFilename

public java.lang.String getFilename()

返回:

the filename

setFilename

public void setFilename(java.lang.String filename)

参数:

filename - the filename to set