Data on more than one sheet of same excel workbook.

mrigya

Hello All,
hw can i export the data on more than one sheet of same excel workbook,different sheet for different conditions,while exporting the report to excel, using excel buffer.

Regards
Mrigya

dkone

Hi,

What are you using to export to excel ?

dkone.

bbrown

Use the CREATESHEET function

mrigya

Will you please eleborate your answer

Sandeep_Prajapati

1)fill excel buffer with your data for first sheet
call CREATESHEET('YoursheetName1')

2)fill excel buffer with your data for 2nd sheet
call CREATESHEET('YoursheetName2')

3)fill excel buffer with your data for 3rd sheet
call CREATESHEET('YoursheetName3')

...and so on.

mrigya

But how to fill the DATA on the second sheet?

Sandeep_Prajapati

CREATESHEET function cretaes a new excel sheet in the workbook and writes all the data you have pushed in excel buffer table, in that sheet.
so,

1)fill excel buffer with your data for first sheet
call CREATESHEET('YoursheetName1'); //will create first sheet
excelBuffer.Deletall;

2)fill excel buffer with your data for 2nd sheet
call CREATESHEET('YoursheetName2'); //will create 2nd sheet
excelBuffer.Deletall;

3)fill excel buffer with your data for 3rd sheet
call CREATESHEET('YoursheetName3');//will create 3rd sheet
excelBuffer.Deletall;

...and so on.