XLXML, the RPG SSML

XLXML, the RPG SSML

page d'accueil
Boite à outils

Cette page a été mise à jour le14 septembre 2009.
Contact

Welcome page
Tools box

Versionning

2005-05-09 first publication
2007-06-10 correction for V5R4 compatibility ; ready for unicode
2009-03-21 update into JP4XL4 (&XLXML3R): color for text is now accessible with FontColor. the Color procedure is usable only for the Interior of a cell

last version : The SaveFiles

XLXML is a partial RPG implementation of SpreadSheet XML version 2003. And SpreadSheet XML2003 is a Microsoft partial implementation of recording an XLS file. For example, SSML2003 don't record the graphs.

So, before starting to code an SSML file in RPG, you may do the job with Excel one time handly, then record the file as an XML file, close Excel, reopen the file with excel and see what come back and what not.

MS Office 2003 XSD files are in XSDREF.MSI and can be found at http://www.microsoft.comthen search for XSDREF.MSI

Today's RPG code is already able to produce this kind of file :

original file generated with RPG, needs Office 11 : XLXML3.XLS

the same file, converted for office 10 :XLXML3_10.XLS

the same file, converted for office 95 : XLXML3_9.xls

The code is today not easy to master (very sensitive to misuse, and not easy to debug). I'm working on making it more efficient.

I recommand you always start from last version of provided sample (XLXML3R) and use the procedures in the same order. The sample covers (commented or not) the whole implemented procedures.

As explained in the code, you normaly never will use low level procedures.

It you ever use merged cells, have in mind that there is a side effet that can be hard to solve : xlxml3 is able to reload a cell : you can start loading a cell with some data then need to change them. On the other hand, when you merge cells, the merged cells (but the first) "disapears" from excel's cells list. Example : you have merged on a row the cells at column 5 to 7 with the data "Title". After merging, the next cell of cell 5 is cell 8. If there is something loaded at cells 6 or 7 (before or after the merging), xlxml don't see the mistake, and you will have an ugly message from excel.

if you got this message: the file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file.

you are using excel 2007. To avoid this message, instead of .XLS, rename your files *.XML

The source code is provided as an open source tool under the GNU General Public License, version 2. In summary, this license specifies:

The code is under copyright
The code can be used internally by organizations for in-house projects free of charge
The code may not be included in products that are sold commercially
If the code is distributed in other open source projects, fixes and enhancements to this project must be provided back to this project

THIS TOOLBOX IS PROVIDED ''AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE PROVIDER OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS TOOLBOX, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.