XLSX Driver stops reading layers after first Chart
|Reported by:||mwtoews||Owned by:||warmerdam|
Description (last modified by mwtoews)
While using the XLSX Driver from OGR on a Excel Workbook with multiple tabs, the driver reads each Worksheet as a Layer, in the order they appear. However, if one of the tabs is a Chart, OGR describes the tab as a Layer (which is should not), and stops reading the remaining tabs of the workbook.
I've prepared a Workbook in Excel 2016 with the following tabs:
With the following behaviour from an OSGeo4W Shell:
C:\Temp\OGR>ogrinfo --version GDAL 2.1.1, released 2016/07/07 C:\Temp\OGR>ogrinfo including_chart.xlsx INFO: Open of `including_chart.xlsx' using driver `XLSX' successful. 1: Sheet1 (None) 2: Chart1 (None)
note that I cannot access Sheet2 without modifying the document to re-order the tabs so that it is before "Chart1". And if I blank the data from "Sheet2", "Chart1" no longer is listed (and I'm not sure why -- I can add this as a separate .xlsx file if needed).
An expected behaviour would only read the spreadsheet tabs, skipping any Charts:
1: Sheet1 (None) 2: Sheet2 (None)