程序包 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
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.AbstractView

  • 字段概要

    字段
    修饰符和类型
    字段
    说明
    private Consumer<org.apache.poi.ss.usermodel.Workbook>
    consumer
     
    private String
    filename
     
    static final 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(String filename, 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; }
    ExcelView(Consumer<org.apache.poi.ss.usermodel.Workbook> consumer)
     

  • 方法概要

    修饰符和类型
    方法
    说明
    protected void
    buildExcelDocument(Map<String,Object> model, org.apache.poi.ss.usermodel.Workbook workbook, jakarta.servlet.http.HttpServletRequest request, jakarta.servlet.http.HttpServletResponse response)
     
    protected org.apache.poi.xssf.streaming.SXSSFWorkbook
    createWorkbook(Map<String,Object> model, jakarta.servlet.http.HttpServletRequest request)
    This implementation creates a SXSSFWorkbook for streaming the XLSX format.
    protected boolean
    generatesDownloadContent()
     
    String
    getFilename()
     
    protected final void
    renderMergedOutputModel(Map<String,Object> model, jakarta.servlet.http.HttpServletRequest request, jakarta.servlet.http.HttpServletResponse response)
    Renders the Excel view, given the specified model.
    protected void
    renderWorkbook(org.apache.poi.ss.usermodel.Workbook workbook, jakarta.servlet.http.HttpServletResponse response)
    The actual render step: taking the POI Workbook and rendering it to the given response.
    void
    setFilename(String filename)
     

    从类继承的方法 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 Consumer<org.apache.poi.ss.usermodel.Workbook> consumer

    • filename

      private String filename

    • SUFFIX

      public static final String SUFFIX
      另请参阅:

  • 构造器详细资料

    • ExcelView

      public ExcelView(String filename, 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(Consumer<org.apache.poi.ss.usermodel.Workbook> consumer)

  • 方法详细资料

    • generatesDownloadContent

      protected boolean generatesDownloadContent()
      覆盖:
      generatesDownloadContent 在类中 org.springframework.web.servlet.view.AbstractView

    • renderMergedOutputModel

      protected final void renderMergedOutputModel(Map<String,Object> model, jakarta.servlet.http.HttpServletRequest request, jakarta.servlet.http.HttpServletResponse response) throws Exception
      Renders the Excel view, given the specified model.
      指定者:
      renderMergedOutputModel 在类中 org.springframework.web.servlet.view.AbstractView
      抛出:
      Exception

    • renderWorkbook

      protected void renderWorkbook(org.apache.poi.ss.usermodel.Workbook workbook, jakarta.servlet.http.HttpServletResponse response) throws IOException
      The actual render step: taking the POI Workbook and rendering it to the given response.
      参数:
      workbook - the POI Workbook to render
      response - current HTTP response
      抛出:
      IOException - when thrown by I/O methods that we're delegating to

    • createWorkbook

      protected org.apache.poi.xssf.streaming.SXSSFWorkbook createWorkbook(Map<String,Object> model, jakarta.servlet.http.HttpServletRequest request)
      This implementation creates a SXSSFWorkbook for streaming the XLSX format.

    • 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
      抛出:
      Exception

    • getFilename

      public String getFilename()
      返回:
      the filename

    • setFilename

      public void setFilename(String filename)
      参数:
      filename - the filename to set