类 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
  • 构造器概要

    构造器
    构造器
    说明
    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)
     
     
    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

    从类继承的方法 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)
  • 方法详细资料

    • 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

      public String getFilename()
      返回:
      the filename
    • setFilename

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