very basic brute force write .xml document from rpg for multi-tab excel documents
use of rpgfree service programs to create .xml file for import into multi-tab worksheets.
some of it is ugly...its not elegant, but there's enough here to start you on your own project.
so...what do we have and what do you need?
the service programs themselves (and related info)
@info.txt - our own documentation on creating service programs...if you're new to this it might help
xml_styles.txt - documentation of the current cell styles the service program knows about
bxml.bnd - the binder source for the service programs
hxml.rpgle - the header file for the service program
xml.rpgle - the service program itself
wxml.pf - the file that will hold the xml for the data
a small and stupid example
testxml.rpgle - just writes a couple cells to a couple sheets to show how the service program is used.
testxmlc.clle - an example of clearing the file, calling the program, sending the xml to a user.
a small example that we actually use daily
every morning the open receivables by salesmen are collected and put into a file, W02440.
the file is basically salesman, customer, current, over00, over 30, over60, over90
a program R02441 reads W02440 and creates the xml for a spreadsheet, one page per saleman, listing each customer and the balances.
W02440.pf - the pf/table with the data
R02441.rpgle - the program that reads w02440 and writes to wxml
C02440.clle - clears the files, calls r02441, sends the wxml file to the user.
lastly...you might wonder why we bother creating the summary file in the middle instead of just going directly to the xml...its because we use the summary file in other places...google charts of the data on our intranet, etc. good question, though...