Excel xml spreadsheet - is it possible to embed images?
.net, excel, xml
Solution
I'm trying do the same export. And I'm stuck solving this problem too. But I've bad news, as MSDN describes here , the only ss:Type possible are:
Enumeration—Number, DateTime, Boolean, String, and Error
If you can open the .xls might this solution help you: http://polymathprogrammer.com/2010/11/10/how-to-insert-multiple-images-in-excel-open-xml/
Unfortunately, for me I still with no solution.
Problem
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.