I want to create XL files from a table in VFP.
I have a table sorted in a particular way, and need to create
a no. of Spreadsheets from this, with subtotals and headings built in
An example:

Col a COL b
Row 1 Annie 100
Row 2 Bart 200
Row 3 Homer 500
Row 4 Total Simpsons @sum(b1..b3)
Row 5
Row 6 Reagan 400
Row 7 Clinton 101
Row 8 Nixon 105
Total Pres. @sum(b6..b8)

The Subtotal descriptions are taken from a Table
and I also waould like to put in the formula (e.g. @sum(b2..b3)
rather than 500, because the users of the spreadsheet
may want to add in rows and I dont want them having
to have to put in the formulas.


I'm wondering how easy it is to do this and if there is any documnetation
around to do this.

Regards,

Gerard