Excel xml spreadsheet - is it possible to embed images?

Question

I'm trying to export data from a web app into excel, but there is a request to include the company's logo at the top of the spreadsheet. My normal method of creating the excel is to create a spreadsheet in excel and save it as an Xml Spreadsheet (Excel 2003). This allows me to build up the xml in code.

However, when attempting to save the excel worksheet as an xml worksheet I get warned that the image will be lost.

So, is it possible to embed an image from my application? I tried base64, but that didn't work.

<Data ss:Type="Base64">base64string here...</Data> isn't valid

Html isn't interpreted either. Is this possible?

Excel 2003 + is the target.

Answer 1

SpreadsheetGear for .NET will let you create Excel workbooks with embedded images (and more).

You can see the "Excel Report with Picture" sample on the ASP.NET Excel Reporting samples page and download the free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC