how to import an excel sheet in a dynamic nav

mohmd

how to import an excel sheet sheet in dynamic nav

RockWithNAV

Replica of Thread

http://forum.mibuso.com/discussion/67860/how-to-import-from-ecxel-to-dynamic-nav#latest

Kishorm

Have a look at how it's in in standard NAV - e.g. Report 81 "Import Budget from Excel"

RockWithNAV

Replica of Thread

http://forum.mibuso.com/discussion/67860/how-to-import-from-ecxel-to-dynamic-nav#latest

Rathi

https://saurav-nav.blogspot.my/2015/07/nav-2013-r2-import-excel-file-using.html

Tiwaz

Using Excel Buffer Table.
I would create a ProcessingOnly report in which I would insert Integer as DataItem and place a FOR loop in OnAfterGetRecord(). In OnPreDataItem you must call OpenBook and ReadSheet functions on ExcelBuffer.
In there you can define a variable that will check for how many rows there are in your Excel sheet and one that will allow you to enter manually from which row you want to start importing.
Then you simply use GET on excel buffer to get wanted cell and then just validate that value to your NAV record using Cell Value As Text from Excel Buffer.