You’re offline. This is a read only version of the page.
Dear All,
I am using NAV 2015. I have created a report to import a report to import an excel file. while trying to import it shows an error
A call to Microsoft.Dynamics.Nav.OpenXml.spreadsheet.WorkbookReader.Open failed with this message.C:\Users\UserName\filename.xlsx
When i run the debugger and check the process it stops in the code XlWrkBkReader := XlWrkBkReader.Open(FileName); in table Excel buffer.
What may be the reason behind this can anyone specify. the excel version in the client and server is also same.
Problem happens client machine only , server machine working properly.
Thanks,
P.Saravanan
*This post is locked for comments
Where is the file actually located? Does the user have enough rights to access that file? Can it open the file directly from that location?
Hi Saravanan,
Please refer below link.
blogs.msdn.microsoft.com/.../nav-pattern-of-the-week-silent-file-upload-and-download
check if XlWrkBkReader variable is set to runonclient=yes. if it's set to no, then the file has to be on the server, not on the client. in that case, before running that command copy the file from client to server with upload or cu file mgmt.
also check if the current user has file read access and the file is not locked.
also try with a different excel doc to check, if the first one is not corrupted.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (