程序包 org.springframework.web.servlet.view.document

类 AbstractExcelView

  • 所有已实现的接口:
    Aware, BeanNameAware, ApplicationContextAware, ServletContextAware, View
    @Deprecated
public abstract class AbstractExcelView
extends AbstractView
    已过时。
    as of Spring 4.2, in favor of AbstractXlsView and its AbstractXlsxView and AbstractXlsxStreamingView variants
    Convenient superclass for Excel document views. Compatible with Apache POI 3.5 and higher, as of Spring 4.0.

    Properties:

    • url (optional): The url of an existing Excel document to pick as a starting point. It is done without localization part nor the ".xls" extension.

    The file will be searched with locations in the following order:

    • [url]_[language]_[country].xls
    • [url]_[language].xls
    • [url].xls

    For working with the workbook in the subclass, see Apache's POI site

    As an example, you can try this snippet: 

     protected void buildExcelDocument(
     Map<String, Object> model, HSSFWorkbook workbook,
     HttpServletRequest request, HttpServletResponse response) {

   // Go to the first sheet.
   // getSheetAt: only if workbook is created from an existing document
         // HSSFSheet sheet = workbook.getSheetAt(0);
         HSSFSheet sheet = workbook.createSheet("Spring");
         sheet.setDefaultColumnWidth(12);

   // Write a text at A1.
   HSSFCell cell = getCell(sheet, 0, 0);
   setText(cell, "Spring POI test");

   // Write the current date at A2.
   HSSFCellStyle dateStyle = workbook.createCellStyle();
   dateStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
   cell = getCell(sheet, 1, 0);
   cell.setCellValue(new Date());
   cell.setCellStyle(dateStyle);

   // Write a number at A3
   getCell(sheet, 2, 0).setCellValue(458);

   // Write a range of numbers.
   HSSFRow sheetRow = sheet.createRow(3);
   for (short i = 0; i < 10; i++) {
     sheetRow.createCell(i).setCellValue(i * 10);
   }
 }
    This class is similar to the AbstractPdfView class in usage style.
    作者:
    Jean-Pierre Pawlak, Juergen Hoeller
    另请参阅:
    AbstractPdfView

    • 构造器详细资料

      • AbstractExcelView

        public AbstractExcelView()
        已过时。
        Default Constructor. Sets the content type of the view to "application/vnd.ms-excel".

    • 方法详细资料

      • setUrl

        public void setUrl​(String url)
        已过时。
        Set the URL of the Excel workbook source, without localization part nor extension.

      • getTemplateSource

        protected org.apache.poi.hssf.usermodel.HSSFWorkbook getTemplateSource​(String url,
                                                                       HttpServletRequest request)
                                                                throws Exception
        已过时。
        Creates the workbook from an existing XLS document.
        参数:
        url - the URL of the Excel template without localization part nor extension
        request - current HTTP request
        返回:
        the HSSFWorkbook
        抛出:
        Exception - in case of failure

      • buildExcelDocument

        protected abstract void buildExcelDocument​(Map<String,​Object> model,
                                           org.apache.poi.hssf.usermodel.HSSFWorkbook workbook,
                                           HttpServletRequest request,
                                           HttpServletResponse response)
                                    throws Exception
        已过时。
        Subclasses must implement this method to create an Excel HSSFWorkbook document, given the model.
        参数:
        model - the model Map
        workbook - the Excel workbook to complete
        request - in case we need locale etc. Shouldn't look at attributes.
        response - in case we need to set cookies. Shouldn't write to it.
        抛出:
        Exception

      • getCell

        protected org.apache.poi.hssf.usermodel.HSSFCell getCell​(org.apache.poi.hssf.usermodel.HSSFSheet sheet,
                                                         int row,
                                                         int col)
        已过时。
        Convenient method to obtain the cell in the given sheet, row and column.

        Creates the row and the cell if they still doesn't already exist. Thus, the column can be passed as an int, the method making the needed downcasts.

        参数:
        sheet - a sheet object. The first sheet is usually obtained by workbook.getSheetAt(0)
        row - the row number
        col - the column number
        返回:
        the HSSFCell

      • setText

        protected void setText​(org.apache.poi.hssf.usermodel.HSSFCell cell,
                       String text)
        已过时。
        Convenient method to set a String as text content in a cell.
        参数:
        cell - the cell in which the text must be put
        text - the text to put in the cell