MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

How to embed image into OpenXML workbook using CGIDEV2?



fixed

This is a followup to my recent post - I haven't found anything in my googling on this - well, nothing that is helpful in an IBM i RPG context.

I have an image that comes along with a workbook when it is saved as XLSX - I want to write to the OpenXML format.

When I save the workbook as 2003 XML, the image is not there. I'm using Excel 2010, BTW.

So is there a way to stream the image into the XML? Once I can get it into the XML, I can just use it for CGIDEV2 very easily.

I've also looked at the contents of a true XLSX - a PKZIP package is what it is, with several XML files and a PNG for the image. The contents of the workbook is spread all OVER the place, so it's not practical to try to figure out where in that mess to put things. I mean, all text strings seem to be located in some "shared strings" XML file, separate from the rest, even if the string appears only one time.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact