Error when we try to read Excel file with OpenXML variable or with Excel buffer. NAVISION 2015

We have a problem to open files from users client.

When we try to open Excel file with openXML dotnet variable, we get an error: A call to Microsoft.Dynamics.NAV.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: “C:\Test.xlsx”

2678.Error.bmp (168 KB)

Same problem we have when we try to open text files or xml file, we get an error that file cant’t open.

We have installed navision service on Server, users are connected from theirs computer to server with Roletailored client.

With same user if we are on server we can open file, but if we try to open file from another computer with same user, we can’t open file and we get an error:

An Exmple of this is on error below:5074.Error2.png:

Is it a custom export function?
My guess that you have not considered that you (or the developer who code this) didn’t think about that when executing this code, then it takes place on the server. So you are also storing the file on an address relative to the server.
So if the user is actually running it on the server, then it works fine, because the file addresses used are the same.
You need to use the functionality available in NAV 2015 to first create the file on the server, and then upload and store it on a location relative to the client.

Hi,

Hope this helps.

saurav-nav.blogspot.in/…/nav-2013-r2-import-excel-file-using.html

Hello Xhevat, I have the exact problem in my Nav2015. Did you reach an appropriate solution?