Reading Charts from Spreadsheet File

May 3, 2016 at 12:45 PM
I have a spreadsheet template that takes embedded data and creates a line chart.

The chart has two line chart entries (one with two data series) and one with a single data series.

The chart displays with the correct data. however, when I try to use EPPLUS to read the worksheet data, it only shows one Drawing (not two) with the two data series in it.

I've looked at the XML description of the Chart from the Excel file (looked inside the file using ZIP and the Chart folder/file and it shows two lineChart elements, but only one of them appears in EPPLUS under the worksheet.Drawings collection.

I can email a copy of the spreadsheet file if someone wants to look at it.

I'm currently using 4.0.4