Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Excel export stuff...
The_Taco
Member Posts: 6
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!
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!
You love me, I love you.
0
Comments
Click on the the following link http://www.mibuso.com/dlinfo.asp?FileID=207 and you will have wonderful tool to export information from Navision to Excel. This should help you.
Thanks
Cheers
Suresh.
But I need to execute this at Run-Time. It's like, instead of using normal report in Navision, I'm using Excel, because I have to many columns (like 50).
Or maybe I can use this tool at run-time via C/AL code?
Yes, you could just create a report with Dataitem integer and in the properties set Maxiteration to 1 and OnAfterGetRecord of the Data item call the link and you should be all set. I too did the same thing when i had to do exactly what you are trying to do.
Thanks
Cheers.
Suresh.