openxml with Uniface

Author: lammersma@hotmail.com (lammersma)

Hi all, My first posting on the new uniface.info site. Looks very good. Hopefully I post this in the right place. For a new customer we need to create output to the OpenXML format. Has anyone experience with this format? I hope there is a library or a set of Uniface components we can use. Kind regards, Peter Lammersma

4 Comments

  1. Hi Peter, it depends what you really need. In fact it's pure XML, so the XML writer may be all you need to get the file done. So it's just a matter of "find out what you really need for your purposes". I had the same to find what is the minimum RTF commands one really need to create a formatted report with headers and footers. I started with a Winword docuemnt which held all the issues I need, saved it as RTF and deleted parts which looked not important. Ended with a remarkably small file compared to all the thins winword put in at the start. Perhaps this strategy would help you to tame the monster. Success, Uli P.S. Unfortunately, I am still with a WinXP (better the devil you know) and a very old MS-Office; so I have no means to experiment a little on that subject.


    Author: ulrich-merkel (ulrichmerkel@web.de)
  2. Hello Uli, I know it must be possible with Uniface. But if someone did it before I would be nice to share this knowledge, isn't. The xlsx format used by Excel 2007 (and more recent) is zipped OpenXML, I believe. Just unzip and all the XML and graphical info is available. Just create the needed maps and files (xml and jpg/png/gif/...) zip it and ready. All can be done with Uniface. Even on Linux and/or without MS Office installed. I wish someone created a Uniface component to do this for me .... Regards, Peter PS. do these required math get more complicated? 4+12 is just to easy...


    Author: lammersma (lammersma@hotmail.com)
  3. Hi Peter, you know my curiosity: If I would have the required MS Office on my notebook, I would be the first to have a look into it. But as I learned from the RTF: you need only to provide some 5% of the xml tags to make it work. So providing a uniface component (if one would not shoot for a ...-fits-all solution) would depend on what you want to do with that EXCEL file: formatting, formulas, data, layout, charts, ... Uli P.S. think the basic math is for the ones who grew up with smartphones (or people like us starting to forget how to add using fingers and toes)


    Author: ulrich-merkel (ulrichmerkel@web.de)
  4. just had some checks with OPENOFFICE generated XMLX file. Unzipped it and checked contents.xml file. Structure to deliver cell-contents seems very easy: < office:body> < office:spreadsheet> < table:table table:name="Sheet1" table:style-name="ta1" table:print="false"> < table:table-column table:style-name="co1" table:default-cell-style-name="Default"/> < table:table-row table:style-name="ro1"> < table:table-cell office:value-type="string"> < text:p>a < /text:p> < /table:table-cell> < /table:table-row> < table:table-row table:style-name="ro1"> < table:table-cell office:value-type="string"> < text:p>b < /text:p> < /table:table-cell> < /table:table-row> < /table:table> < table:table table:name="Sheet2" table:style-name="ta1" table:print="false"> < table:table-column table:style-name="co1" table:default-cell-style-name="Default"/> < table:table-row table:style-name="ro1"> < table:table-cell/> < /table:table-row> < /table:table> < table:table table:name="Sheet3" table:style-name="ta1" table:print="false"> < table:table-column table:style-name="co1" table:default-cell-style-name="Default"/> < table:table-row table:style-name="ro1"> < table:table-cell/> < /table:table-row> < /table:table> < /office:spreadsheet> < /office:body>


    Author: ulrich-merkel (ulrichmerkel@web.de)