Ok, i’m very new to Navision and its C/AL language. The task I was asked for is to export data from Navision to Excel. I know how to open or create Excel document from C/AL, but now, I need to transfert the data. I found some source code that explain me how to transfert the data by cell. The thing is that this method will be way to long to accomplish, I’ve got like 40k row to transfert from a table in Navision. Is there any other do to this task? Help would be greatly appreciated!
Have you taken a look @ this: Navision Exporter to excel? http://www.mibuso.com/dlinfo.asp?FileID=207 I think you need to be using 3.6 or higher though. Also, this has been covered a few times - if you search the forum for EXCEL you’d probably find your answer there too.
This application seems very nice but I need to generate this stuff at Run-Time. I’ll try to search the forum for an anwser. Thx a lot.
Hi, There is no problem with the number of rows. You only have to do the programming once for one row and then iterate through the Navision table to export all records. One word of advice, though: if you have 40.000 records to export and this quantity will increase in the future, Excel will no longer be an option as it only supports 65.536 rows.
Ok this will seem kinda dumb but is there any search option in this forum?
“User Forum” (top-left Menu) → “Search”