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.
Thanks in advance,