Create Excel Worksheet

-matrix-

I need to create a report that creat a file excel with different Worksheet.

I write this code:

CLEAR(xlApp);
IF NOT CREATE(xlApp) THEN
   ERROR()
ELSE
   XlWorkBook := xlApp.Workbooks.Add;

XlWorksheet1.Name := 'Worksheet 1';

If i need to export in the same file but create and change worksheet how is the right sintax?

Thanks

rsaritzky

I am not sure what you mean when you say you need to "export in the same file but create and change worksheet how is the right syntax?". If you try to explain a little more what you are trying to do, I can try to give you some examples. Do you want to create a new worksheet, then copy the contents of another sheet?

I'll try to help.

Ron

Marije_Brummel

Try using the excel buffer table.

http://www.mibuso.com/dlinfo.asp?FileID=596

-matrix-

Thanks Guys but i Solved

xlApp1.ActiveWorkbook.Sheets.Add();


XlWorkSheet1 := xlApp1.ActiveSheet;
XlWorkSheet1.Name := 'Worksheet1 ;

xlApp2ActiveWorkbook.Sheets.Add();


XlWorkSheet2:= xlApp1.ActiveSheet;
XlWorkSheet2Name := 'Worksheet2;