Use or replicate the "Send to Excel" functionality with code

steinarsig

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?

vremeni4

Hi,

"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.