Report - OnPreReport() IF PrintToExcel THEN BEGIN CREATE(Excel); //sheeet 1: Workbook := Excel.Workbooks.Add(-4167); Worksheet := Excel.ActiveSheet; Worksheet.Name := 'Name1'; //--- sheet 2: Worksheet:=Excel.Sheets.Add(); Worksheet:=Excel.ActiveSheet; Worksheet.Name:='Name2'; END;
Comments
this will create 2 sheets in Excel, "Data" and "Info"
Way too simple.
I was able to:
open an Excel session if the request page has a checkbox checked.
then, create a spreadsheet within each of the Report sections & write away.
A lot of happy people now.