类 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 Consumer<org.apache.poi.ss.usermodel.Workbook>
private String
static final String
从类继承的字段 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
-
构造器概要
构造器构造器说明@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
(Map<String, Object> model, org.apache.poi.ss.usermodel.Workbook workbook, jakarta.servlet.http.HttpServletRequest request, jakarta.servlet.http.HttpServletResponse response) void
setFilename
(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
-
字段详细资料
-
consumer
-
filename
-
SUFFIX
- 另请参阅:
-
-
构造器详细资料
-
ExcelView
@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
-
-
方法详细资料
-
buildExcelDocument
protected void buildExcelDocument(Map<String, Object> model, org.apache.poi.ss.usermodel.Workbook workbook, jakarta.servlet.http.HttpServletRequest request, jakarta.servlet.http.HttpServletResponse response) throws Exception- 指定者:
buildExcelDocument
在类中org.springframework.web.servlet.view.document.AbstractXlsView
- 抛出:
Exception
-
getFilename
- 返回:
- the filename
-
setFilename
- 参数:
filename
- the filename to set
-