4D =3D> XLSX

Dennis, Neil (4/25/14 1:18PM)
Keisuke Miyako (4/25/14 4:58PM)


Dennis, Neil (4/25/14 1:18 PM)

Cc: "Scott Stan \(DCUS/SPP\)" <Stan.Scott@...
<838740227206E84F82973FF5D9EA59B73BCA0DD5@...

color><param>00000,0000,DDEE/param>AAny chance you'd be interested in
sharing some of your thoughts/hints on writing to XLSX format?
/color>
XLSX is just a collection of XML files in a zip container. There is no
other magic. I write out the xml files using 4D code, then use 7Zip to
compress them, rename the extension and its done.

Use the Open Office XML specification
https://www.openoffice.org/xml/xml_specification.pdf

In my case I boiled this down to about 30 wrapper methods for adding
and naming sheets, defining and setting fonts, borders, adding
numbers, dates and formulas that fit my need.

It may take a bit to get used to the specification... and you can
always create a document using Excel, change the extension from xlsx
to zip and un-zip it and look at the files.

I have been considering packaging this code along with the PDF writer.
I will let the group know if I end up doing that.

Neil

Keisuke Miyako (4/25/14 4:58 PM)

this plugin

https://github.com/miyako/4d-plugin-opc

allows you to inspect/read/write resources inside an OOXML document,
but
you will need to manipulate the XML yourself.

you won?=A2?=82®=E2&Ntilde;Ęt have to zip/unzip the file, or parse
the _rels xml, it
will use
libz and libxml to go directly into the archive.

miyako

On 2014/04/25 22:18, "Dennis, Neil" <ndennis@... wrote:

color><param>8826F,0000,8219/param>AAny chance you'd be interested in
sharing some of your thoughts/hints
on writing to XLSX format?
/color><color><param>00000,0000,DDEE/param>
XLSX is just a collection of XML files in a zip container. There is no
other magic. I write out the xml files using 4D code, then use 7Zip to
compress them, rename the extension and its done.

Use the Open Office XML specification
https://www.openoffice.org/xml/xml_specification.pdf

In my case I boiled this down to about 30 wrapper methods for adding
and
naming sheets, defining and setting fonts, borders, adding numbers,
dates
and formulas that fit my need.

It may take a bit to get used to the specification... and you can
always
create a document using Excel, change the extension from xlsx to zip
and
un-zip it and look at the files.

I have been considering packaging this code along with the PDF writer. I
will let the group know if I end up doing that.

Neil
/color>

Reply to this message

Summary created 4/25/14 at 6:57PM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com