Export to Excel

nav_126

Dear all,

I have a problem regarding export to excel using excel buffer concept in Navision 4.0 SP3.

When we export to excel, we call the function createsheet and enter sheet name.

But i want system to enter data directly to Sheet1 of excel sheet. is there any way to do this?

Regards
Navision Developer

Becka

Hi
You can use Automation and create sheet through code... ( sounds like an option )
good luck

nav_126

which Automation i should use? any idea?

Its urgent please,



Regards
Navision Developer

sfo

Hello,

The Automation is Microsoft Excel 11.0 Object Library.Application (12 for Office 2007 I guess)

Sample code for creating the XLS and selecting the Active sheet:

CREATE(xlApp);
xlBooks := xlApp.Workbooks;
xlBooks.Add;
xlBook := xlApp.ActiveWorkbook;
xlSheet := xlApp.ActiveSheet;  

Hope it helps.