poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56800] New: Exception for XLSB files should indicate that the file format is unsupported
Date Fri, 01 Aug 2014 01:55:11 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=56800

            Bug ID: 56800
           Summary: Exception for XLSB files should indicate that the file
                    format is unsupported
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: nirk.niggler@gmail.com

XLSB files are unlikely to be supported, and the exception probably should give
some indication that the file is not in a supported format.

There appear to be a few ways to determine whether a file is XLSB (as opposed
to XLSX or XLSM):

1) XLSB content types:

- workbook application/vnd.ms-excel.sheet.binary.macroEnabled.main
- sharedStrings application/vnd.ms-excel.sharedStrings
- worksheet application/vnd.ms-excel.worksheet
- styles application/vnd.ms-excel.styles

2) File extension: ".bin" for the workbook or worksheets is a good sign of an
XLSB file.

Looking at other open source projects:

- python XLRD https://github.com/python-excel/xlrd raises an error if
xl/workbook.bin is a file in the package

- javascript js-xlsx https://github.com/SheetJS/js-xlsx runs XLSB parsers if
the relevant files end with ".bin"

- libreoffice has some information available at
https://github.com/LibreOffice/core/blob/master/oox/source/dump/xlsbdumper.ini

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message