Exporting to a new document

(0) Share

Report

Posted on by Community Member

Hi, I Have this code which is used when exporting to excel from Navision. This code is currently is looking for an existing document to update, how can I change this for creating a fresh new document.

recCPSetup.FINDFIRST;

strFilepath:='U:\CustomerParts.xlsx'; //Specify the location where the excel file is stored locally

IF ISCLEAR(xlApp) THEN
CREATE(xlApp, FALSE, TRUE);

xlApp.Visible(TRUE);

//1. Opening the excel file
xlBook:=xlApp.Workbooks.Open(strFilepath);//specify your file path with the filename.xls(x)

xlBook:=xlApp.ActiveWorkbook;

//2. Specify the excel sheet name
xlSheet := xlBook.Worksheets.Item('Sheet1');

Name DataType Subtype Length
xlApp / Automation / 'Microsoft Excel 16.0 Object Library'.Application
xlBook / Automation / 'Microsoft Excel 16.0 Object Library'.Workbook
xlSheet / Automation / 'Microsoft Excel 16.0 Object Library'.Worksheet

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

xlBook:=xlApp.Workbooks.Open(strFilepath);//specify your file path with the filename.xls(x)

Remove this line and check

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks however It Errors on this Line

xlSheet := xlBook.Worksheets.Item('Sheet1');

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Try using Create Function and pass automation variable of type Application.

Please refer:

https://msdn.microsoft.com/en-us/library/dd355255(v=nav.90).aspx

http://forum.mibuso.com/discussion/927/tips-tricks-excel-automation

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

please check excel buffer table.

functions in this table will give you idea.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You need to rewrite it either using excel buffer or excal automation

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm trying to avoid using Excel Buffer as I want to set the width of columns, and as far as I'm aware it can't be done with Excel Buffer.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Final working solution:

IF ISCLEAR(xlApp) THEN

CREATE(xlApp, FALSE, TRUE);

xlBook:=xlApp.Workbooks.Add;

xlSheet := xlBook.Worksheets.Item('Sheet1');

Code...

xlSheet.Activate();

xlApp.Visible(TRUE);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Good afternoon, how could I create several graphics on an excel sheet with navision automation?

Was this reply helpful? Yes No