Excel 2003 XML Format and Images
-
Is there any way to get an Excel 2003 xml file to show images? I understand they can't be included in the document, but is there a way to reference images by URL and have them shown when it is opened? Thanks -c
GibbleCH wrote:
Excel 2003 xml file
Excel 2003 doesn't support XML as a workbook format. I don't get what you're really trying to do.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
GibbleCH wrote:
Excel 2003 xml file
Excel 2003 doesn't support XML as a workbook format. I don't get what you're really trying to do.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008Yes, it does. It supports a version of SpreadsheetML prior to the current xlsx format. For example:http://aspalliance.com/471_Convert_XML_To_an_Excel_Spreadsheet_Using_XSL.all[^] But this version does not support images/pictures/macros etc. I was wondering if someone had a work around that would allow me to include images in these documents.
-
Yes, it does. It supports a version of SpreadsheetML prior to the current xlsx format. For example:http://aspalliance.com/471_Convert_XML_To_an_Excel_Spreadsheet_Using_XSL.all[^] But this version does not support images/pictures/macros etc. I was wondering if someone had a work around that would allow me to include images in these documents.
Hmm...I had no idea. Well, depending on how you're doing this, it may or may not be supported. If you are trying to embed the image data directly into the XML, it's not supported. If you are using an external file to store the image, then you might get away with it. This[^] is the best discussion I could find on the subject.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
Hmm...I had no idea. Well, depending on how you're doing this, it may or may not be supported. If you are trying to embed the image data directly into the XML, it's not supported. If you are using an external file to store the image, then you might get away with it. This[^] is the best discussion I could find on the subject.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
I had found that, unfortunately it's using the new SpreadsheetML format in use by Excel 2007, not Excel 2003
Yeah, I was kind of shocked at what that file really is. Have you tried renaming that file to whatever.ext.zip?? Pretty interesting what you find inside.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
Yeah, I was kind of shocked at what that file really is. Have you tried renaming that file to whatever.ext.zip?? Pretty interesting what you find inside.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008Yes, and I like the format, it's not perfect, but it's fast and relatively simple to create excel files for consumption from your existing data without a dependence on com access to excel. Unfortunately, it appears I may be stuck with 2003 as we want this doc to be fairly accessible. Which means slow com calls to create the document, unless I can find a way to reference images in the older 2003 SpreadsheetML format