>Hi guys
>
>I need to do 2 things:
>
>1) from my current cursor I need to produce 3 worksheets in the same book, each being more of a summary of the previous.
>i.e. I have a cursor with all the data, cut down to sub-totals and totals, and cut down to just totals (and a grand total for each, of course). I know how to reduce the cursor for each sheet, but how to include each one in the same book.
>
>2) VFP currently does the above totals/sub-totals but my users would prefer the SUM() function, as they may need to insewrt extra rows in the s/s/ afterwards. I imagine this is a bit tricky.
>
>A tall order?
>
>Thanks for listening
>
>Terry
Hi Terry,
Have look at rep2excel tool here in downloads. ( download#
14800 )
It is class object with wrappers for most of common excel writing tasks.
You can write entire tables,arrays,delimited strings, set formulas, fonts
print area, insert pictures etc. at any position in excel file using simple wrapper calls. (class methods)
Also, it has embeded simple reporting engine (grouping,bands etc)
Will save you of hundreds of lines of complicated/repetive automation code.