Export to Excel on Multiple Sheets for Multiple DataItems

sabzam

Hi All,

So I have a report I need to export to excel

I have 3 data items and I want each data item on seperate Sheets but in the same work book

Can you please help me with this as it seems it cannot be done

I have inserted

TempExcelBuffer.CreateBook;

in the onPreData Item of the first DataItem and subsequently

TempExcelBuffer.CreateSheet(Text000,Text000,COMPANYNAME,USERID);
TempExcelBuffer.GiveUserControl;

in on PostDataItem of each other Data Item but is giving the following error

" This Automation Variable has not been instantiated. You can instantiate it by either creating or assigning it"

Can you please help me with this

Thanks