problem in creation of work sheet

shweta

Hi,

I want to create two excel sheets in a single workbook How i can do it.
Thanks in advance.
Pls its urgent

mohana_cse06

what did you try so far?

shweta

mohana_cse06 wrote:

what did you try so far?

I tried to create second sheet just after the first sheet but it is replacing the first one

mohana_cse06

Can you us the code?

shweta

yes I can

geose

hi, are you creating the excel book by table excel buffer (370) or by automation??


if you are creating the excel book by table 370, try this.



in the table 370 create a new function named AddSheet whit that :


AddSheet()

XlWrkBk := XlApp.ActiveWorkbook;
XlWrkSht := XlWrkBk.Worksheets.Add;



now when you call the table 370 in a report try this;

XlBuffer.Createbook; // this only call once time because this create the excel book
XlBuffer.CreateSheet('title 1,'title2',COMPANYNAME,USERID);
XlBuffer.AddSheet;
XlBuffer.GiveUserControl;


XlBuffer is a type record from Excel Buffer