Add report output to an existing file

rbuser

Hi,

I have to run a daily sales report every night. The results are
exported to an excel file. is it possible to append the results of the
report to an existing excel file.

Arno

rbuser

Arno Verhoeven wrote:


Using Delphi XE, RB 12.05

nardmoseley

RB can be used to generate multiple reports to a single XLS file, but it
cannot generate to an existing XLS file. If you have Excel installed on the
machine, perhaps you could try using the COM Excel components to merge the
files or copy the rows from one document to another. I have not used these
components, but might be worth researching what they can do.


-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com