Report SaveasExcel and re-import via excelbuffer

steve1

Hi folks,

has anybody done this in NAV2015:

Save a report as excel and try to import the file via excelbuffer to extend it. It seems that Microsoft.Dynamics.Nav.OpenXml has some problems to open because of missing xml-part in the file so the message.

Next question: Has anybody tried to set the parameters RunOnClient to "false" of all Microsoft.Dynamics.Nav.OpenXml, using a copy of table excelbuffer? I tried this but the XlHelper won't open the file and shows a nice message. Even though I checked that the file is at the right place. The file exists but the server session won't open it - saying it not exists or ... or ... Uploading to the server is not needed because I print out the report to xlsx-File on server side. No problem to install excel on server, its done. This is because we have to handle many excel files so if one file takes 6 seconds to create via report and extend via client side running Microsoft.Dynamics.Nav.OpenXml it will take mor than half a hour to create 50 files.

Greetings

steve