Re: How to embed image into OpenXML workbook using CGIDEV2?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yeah, Richard, I would have thought that, as well. But when saving to 
the old 2003 XML format, the image is dropped - I get a warning about 
incompatible stuff.

I did see some stuff online about Base64 but would have to buy something 
to get it, it seems.

Since this is an internal report, I can maybe convince the stakeholder 
that the corporate logo isn't needed - we shall see.

OH, and congrats on the new deal with Help Systems.

Vern

On 7/4/2014 8:20 AM, Richard Schoen wrote:
> Vern,
>
> If you're just creating a template with an image in it have you tried using the SaveAs from Excel ?
>
> Maybe I'm missing something though :-)
>
> I would think the image would probably embed as Base64 in the XML format perhaps.
>
> Been a while since I've done embedded image stuff.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
> ------------------------------
>
> message: 8
> date: Thu, 03 Jul 2014 17:10:04 -0500
> from: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
> subject: Re: How to embed image into OpenXML workbook using CGIDEV2?
>
> The purpose is to have the XML that has all the sheets and rows within -
> the XLSX is more than XML, as you know - it is a package that consists
> of several things - XML stuff, PNG files, etc. And is all packaged up as
> a PKZIP archive. And yes, I did see "openXML" in several of the XML
> files contained therein - so I take your point.
>
> Those files include things like styles.xml, sharedstrings.xml,
> sheets.xml - the latter has SOME of the data - the non-string stuff, it
> appears.
>
> If it were possible to get a single XML file with all this openXML in
> one place, I'd be happy as a clam - NOT in a cooking pot!
>
> Because I want to use CGIDEV2 to create these workbooks, it has to be in
> a single file with XML content - the only option in Excel 2010 that I
> see for saving a workbook in XML format is "XML Spreadsheet 2003", so
> that is what I mean.
>
> So now that we've clarified this for the other folks, do you have a
> solution for embedding an image in THAT XML, that will display? It would
> be a one-time job to get that stream in place, since, afterwards, it'd
> be part of one of the CGIDEV2 sections.
>
> Cheers
> Vern
>
> On 7/3/2014 4:01 PM, John Yeung wrote:
> > Vern,
> >
> > I think we need to get some clarity with terminology, which is
> > definitely confusing when it comes to Excel formats.
> >
> > The .xlsx format used by default in modern versions of Excel *IS*
> > OpenXML.  (It's called "Open" because it's an open standard.)
> >
> > If you are talking about the XML which is generated by older (before
> > 2007) versions of Excel, that is *not* OpenXML.  That is most properly
> > just called Excel XML.  It is sometimes referred to as "XML
> > spreadsheet".
> >
> > And if all that isn't enough, OpenOffice.org had its own XML format as
> > well, which is not the same as either of the above Excel formats.
> > Understandably, a lot of people think of OpenOffice (formerly
> > StarOffice, way back when) when they see "OpenXML".
> >
> > So, if you want to be sure you're on the same page with someone else,
> > I strongly recommend avoiding the term "OpenXML".  When you said "2003
> > XML" (meaning XML emitted by Excel 2003), I thought that was not a bad
> > choice of terminology.  For that format, you need to mention the 2003,
> > because without specifying an Excel version, many people will just
> > assume you mean .xlsx.
> >
> > John Y.