Images in Excel (xls) files

[Erwin]

Hi,

I have a simple Excel file with just one sheet and one image in .xls and in .xlsx (attached in the zip file).

When reading the files using the XlsFormatProvider or XlsxFormatProvider, I get a workbook. When iterating the shapes on every sheet, I have a different result. I can retrieve the image using the XlsxFormatProvider in the xlsx file, but I'm not getting any shapes in the .xls file using the XlsFormatProvider.

Some code below:

var provider = new XlsxFormatProvider();
using (var fs = File.OpenRead("image.xlsx"))
{
    var workbook = provider.Import(fs);
    Assert.AreEqual(workbook.ActiveWorksheet.Shapes.Images.Count(), 1);
}

Should I be doing this differently? Or is this a known limitation?

I'm using version 2021.3.909.40.

Edit: just noticed that the same goes for charts.

[Tanya]

Hello Erwin,

XlsFormatProvider currently doesn't support images and charts. We have logged a request about the images support on our public portal: SpreadProcessing: Add support for images when importing XLS, and I have just opened a new one on your behalf for the charts: SpreadProcessing: Add support for charts when working with XLS. You can use the linked items to vote for the implementation of the tasks and subscribe to them if you would like to receive updates about changes in their status.

Hope this information is useful.

Regards,
Tanya
Progress Telerik