XLSX Driver stops reading layers after first Chart

[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)

[Even Rouault]

In 35709:

XLSX: only list worksheets (and no charts) as layers (fixes #6680)

[Even Rouault]

In 35710:

XLSX: only list worksheets (and no charts) as layers (fixes #6680)