|
Would anyone out there have any tips on outputting to Excel,
namely "feeding" separate tabbed-sheets?
Currently, I output a set of 1 to 7 reports per county to a
text file, 1 file per county, with each report flowing sequentially, or
vertically, within the file. These 95 files are converted to Word and each
of the word files are distributed to each of the counties. Now, the desire
is to have the output contained in an Excel file. To me, the only really
good solution for the clients is to create 1 Excel file per county - just like
now - but to place the output of each report into its own tabbed sheet.
I'm not even worrying about any sort of @SUM()'s at this point, as the reports
can vary in the number of detail rows per report-county. I just want to
maintain the 2-D, row-column matrix organization from the current reports when
they are in Excel.
However, how to do this, without writing lower-level code,
learning more than I want to about OLE/BIFF files, or manually iterating through
something 95*N_Reports/month, is my problem.
If it helps, the reports coming out of RBase are driven by
either a TABLE or a VIEW. I have also toyed with querying RBase from Excel
to produce the result-set to populate a sheet. It worked with a TABLE -
although Excel echoed that there were no available tables - but
I couldn't get it to work with a VIEW. I am surely lacking some
useful information in this area.
Any help on any approach or part of this would be
appreciated.
(RBWIN 6.5++ last build - okay, okay, I'll be gettin' round to
>=v7 before long - WinXP, Office/Excel 2003)
Thanks,
Steve in Memphis
|
