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

Thanks, Ken - my problem isn't getting it into Base64 - well, I'd have work on that - my problem is, can it be used in XML Spreadsheet format - the Excel 2003 format - not Open XML.

So this is a start if I go that route.

I've just about finished a first round with CGIDEV2 - SOOOOO much faster, and more Excel attributes are possible, including nice borders and number formats and all that were not preserved using the SQL2JXL Command.

I mean seconds instead of a minute per workbook!!

Vern

On 7/4/2014 11:57 AM, Ken Sims wrote:

Hi Vernon -

On Fri, 04 Jul 2014 08:25:44 -0500, Vernon Hamberg
<vhamberg@xxxxxxxxxxxxxxx> wrote:

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

Base64 encoding is pretty simple. Every three bytes of input is
converted to four bytes of output that are all standard ASCII
characters.

You just have to split the three bytes into four groups of six bits
each and treated that as an unsigned integer offset into an array of
the output characters.

There is padding if the total number of input bytes isn't a multiple
of three so that the total number of output bytes is a multiple of
four.

Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.