Create Multiple ExcelSheet for exporting data in different sheet

Hello

How to create multiple excel sheet without changing excel buffer table.

and how to insert data in different sheet?

Thanks

Just have a look at this link which will help you

http://www.mibuso.com/forum/viewtopic.php?f=23&t=51745&start=0

http://dynamicsuser.net/forums/p/52711/275920.aspx

Can you tell me how to do it without changing anything on excelbuffer and also using excel buffer as is.

can i create this function in my own report and use excel buffer for first two sheet like info and data

Hi i have added function AddSheet() in ExcelBuffer table and calling it like this

ExcelBuf.CreateBook;

ExcelBuf.CreateSheet(Text101,Text102,COMPANYNAME,USERID);

ExcelBuf.AddSheet;

ExcelBuf.CreateSheet(Text103,’’,COMPANYNAME,USERID);

but getting error excel buffer is already exist and rowno=1 and col no=1

can u explain concept how to add data to perticular sheet after adding sheet in to work book

Hi i have added function AddSheet() in ExcelBuffer table and calling it like this

ExcelBuf.CreateBook;

ExcelBuf.CreateSheet(Text101,Text102,COMPANYNAME,USERID);

ExcelBuf.AddSheet;

ExcelBuf.CreateSheet(Text103,’’,COMPANYNAME,USERID);

but getting error excel buffer is already exist and rowno=1 and col no=1

can u explain concept how to add data to perticular sheet after adding sheet in to work book

Hi i have added function AddSheet() in ExcelBuffer table and calling it like this

ExcelBuf.CreateBook;

ExcelBuf.CreateSheet(Text101,Text102,COMPANYNAME,USERID);

ExcelBuf.AddSheet;

ExcelBuf.CreateSheet(Text103,’’,COMPANYNAME,USERID);

but getting error excel buffer is already exist and rowno=1 and col no=1

can u explain concept how to add data to perticular sheet after adding sheet in to work book

Hello I have Created AddSheet function in Excel Buf and i have report like this

Employee

Integer

want to print data from employee in one sheet and integer on other sheet

Calling CreateSheet on Employee PostDataitem and

Calling AddSheet and CreateSheet on Integer PostDataItem but it is not working

giving me error u cannot rename sheet

Can you please help me out

Hello I have Created AddSheet function in Excel Buf and i have report like this

Employee

Integer

want to print data from employee in one sheet and integer on other sheet

Calling CreateSheet on Employee PostDataitem and

Calling AddSheet and CreateSheet on Integer PostDataItem but it is not working

giving me error u cannot rename sheet

Can you please help me out