Export report to existing excel file

kam333

Hello, all.
How to export data from navision report in existing excel worksheet?
At 1st I open excel file and then insert data using this function:

EnterCell(RowNo : Integer;ColumnNo : Integer;CellValue : Text[50];Bold : Boolean;Italic : Boolean;UnderLine : Boolean) 
TempExcelBuffer.INIT; 
TempExcelBuffer.VALIDATE("Row No.",RowNo); 
TempExcelBuffer.VALIDATE("Column No.",ColumnNo); 
TempExcelBuffer."Cell Value as Text" := CellValue; 
TempExcelBuffer.Formula := ''; 
TempExcelBuffer.Bold := Bold; 
TempExcelBuffer.Italic := Italic; 
TempExcelBuffer.Underline := UnderLine; 
TempExcelBuffer.INSERT;

andrejsm

There should be something like that:

CASE Option OF
Option :: "Update Workbook" : BEGIN
TempExcelBuffer.OpenBook(FileName,SheetName);
TempExcelBuffer.CreateSheet(SheetName,'',COMPANYNAME,USERID);
TempExcelBuffer.GiveUserControl;
END;
Option :: "Create Workbook" : BEGIN
TempExcelBuffer.CreateBook;
TempExcelBuffer.CreateSheet(SheetName,'',COMPANYNAME,USERID);
TempExcelBuffer.GiveUserControl;
END;
END;

kam333

Function CreateSheet create a new worksheet in xls workbook, but I modified them to add data in existing sheet.
Thanks for help