GeoServer
  1. GeoServer
  2. GEOS-4461

Enhance Excel WFS output plugin, including adding support for Excel 2007 workbooks

    Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2-beta1
    • Component/s: Excel
    • Labels:
      None
    • Testcase included:
      yes
    • Patch Submitted:
      Yes
    • Number of attachments :
      1

      Description

      Attached is a patch that enhances the current Excel WFS output plugin. Better formatting and data truncation handling are added for Excel 97 files. Support for OOXML Excel 2007 files is also added (output format "excel2007").

      Excel 2007 workbooks can handle up to 1,048,576 rows and 16,384 columns, so they are ideal for downloading large datasets. Unfortunately these large POI XML workbook objects also take up a huge amount of memory, so a workaround published by one of the POI authors is implemented for Excel 2007. If POI's memory usage improves in the future, the overriding Excel 2007 write method can be removed and the Excel 2007 output will use the standard POI ss usermodel.

      Patch included updated test cases and also upgrades POI to version 3.7.

        Activity

        Hide
        Shane StClair added a comment -

        Ok, changes committed and closing issue. Thanks!

        Show
        Shane StClair added a comment - Ok, changes committed and closing issue. Thanks!
        Hide
        Shane StClair added a comment -

        Changes applied, including upgrade of POI to 3.7 and addition of excel2007 output format support.

        Show
        Shane StClair added a comment - Changes applied, including upgrade of POI to 3.7 and addition of excel2007 output format support.
        Hide
        Andrea Aime added a comment -

        Mass closing all issues that have been in "resolved" state for more than a month without further comments

        Show
        Andrea Aime added a comment - Mass closing all issues that have been in "resolved" state for more than a month without further comments
        Hide
        Justin Deoliveira added a comment -

        Reopening in order to reassign to 2.1-beta2 release

        Show
        Justin Deoliveira added a comment - Reopening in order to reassign to 2.1-beta2 release
        Hide
        Andrea Aime added a comment -

        Switching all issues that have been in "resolved" state for more than one month without further comments to "closed" status

        Show
        Andrea Aime added a comment - Switching all issues that have been in "resolved" state for more than one month without further comments to "closed" status

          People

          • Assignee:
            Shane StClair
            Reporter:
            Shane StClair
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: