Opened 7 years ago

Last modified 7 years ago

#6680 closed defect

XLSX Driver stops reading layers after first Chart — at Version 1

Reported by: Mike Taves Owned by: warmerdam
Priority: normal Milestone: 2.1.2
Component: default Version: unspecified
Severity: normal Keywords:
Cc:

Description (last modified by Mike Taves)

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:

  • Sheet1
  • Chart1
  • Sheet2

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)

Change History (2)

by Mike Taves, 7 years ago

Attachment: including_chart.xlsx added

comment:1 by Mike Taves, 7 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.