Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 268 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Use or replicate the "Send to Excel" functionality with code
steinarsig
Member Posts: 8
Hi
I am developing in NAV2013R2 and I really like the "Send to Excel" button available in most pages. Now I need to export some table data along with several calculated fields. I would really like to replicate the exact look and feel of the "Send to Excel" button. By look and feel, I mean the sorting feature, color formatting, automatically opening in Excel, etc.
I know I could do a report and use the Print -> Send to Excel feature, but that does not provide the same nice look. I believe I could accomplish most of this with the Excel Buffer but getting the same formatting etc. would be way too much work (if possible).
I could create a page with my data, but that would require changes to the underlying table as the Send to Excel feature only exports table fields, not extra fields I would calculate.
Currently I have the data I need to export in an XMLport as I have been exporting this as a txt file, but I could switch to a Report, Codeunit or whatever.
Is the "Send to Excel" function accessible at all through code?
I am developing in NAV2013R2 and I really like the "Send to Excel" button available in most pages. Now I need to export some table data along with several calculated fields. I would really like to replicate the exact look and feel of the "Send to Excel" button. By look and feel, I mean the sorting feature, color formatting, automatically opening in Excel, etc.
I know I could do a report and use the Print -> Send to Excel feature, but that does not provide the same nice look. I believe I could accomplish most of this with the Excel Buffer but getting the same formatting etc. would be way too much work (if possible).
I could create a page with my data, but that would require changes to the underlying table as the Send to Excel feature only exports table fields, not extra fields I would calculate.
Currently I have the data I need to export in an XMLport as I have been exporting this as a txt file, but I could switch to a Report, Codeunit or whatever.
Is the "Send to Excel" function accessible at all through code?
0
Comments
"Send to Excel" uses Rapid start codeunits in the background.
In other words you can piggyback this standard functionality to achieve what you want.
Regarding Rapid Start take a look at this link
http://msdn.microsoft.com/en-us/library/jj128098%28v=nav.70%29.aspx
or take a look at this how to video
https://www.youtube.com/watch?v=AuRQGitHfJw
I know that Rapidstart is used in these examples for the configuration purposes, but it can also be used for everyday data import export.
We had similar requirements for one client and this was how we did it.
I hope this helps.
Thanks.