Share
ReportHi Experts,
please tell me how to import the excel file using cal code in nav 2016.
Thank you
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi Experts,
please tell me how to import the excel file using cal code in nav 2016.
Thank you
*This post is locked for comments
Hi Ashwini,
- I think file name should be 'C:\...\...xlsx':
ServerFileName := FileManagement.UploadFile(Text001,'ExcelTxt'); // ExcelTxt is excle file name
- To insert to main table, loop excel buffer and write insert code to main table.
Hi Experts,
i can insert the data in excel buffer using import but its not inserting my main table. please give any solution.
thank you
Hi Sir,
where i need to enter the excel file name
IF CloseAction = ACTION::OK THEN BEGIN
ServerFileName := FileManagement.UploadFile(Text001,'ExcelTxt'); // ExcelTxt is excle file name
IF ServerFileName = '' THEN
EXIT(FALSE);
SheetNAme := ExcelBuffer.SelectSheetsName(ServerFileName);
IF SheetNAme = '' THEN
EXIT(FALSE);
END;
eventhough im getting error please enter the filename.
please give any solution.
thank you
Hi Ashwini.123,
Take a look at table 370 Excel Buffer.
A nice thread from Chris D'Silva https://www.cloudfronts.com/importing-excel-file-microsoft-dynamics-nav-using-excel-buffer/
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
