Can I upload the '.xls' file to Dynamics 365 using OfficeOpenXml?

(0) Share

Report

Posted on by Michael Antony

314

Hi expert. Please help me.

I can't upload the excel .xls file in the excel upload feature that I made, the error description is like this.
'The file is not an valid Package file. If the file is encrypted, please supply the password in the constructor.'

I've specified the accepted file types in the code ('.xls,.xlsx'), does anyone know the solution? Can I actually upload .xls file to the solution?

* When I debug the code,, I am not getting much information from the call stack when the error occur

In the output section of Debugging, I get error message --> Exception thrown: 'System.IO.InvalidDataException' in EPPlus.dll

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

WillWU 22,361 on at

Like (0)

Report

Hi Michael Antony,

EPPlus does not work with the XLS format.

You could use Microsoft.Office.Interop.Excel to convert .xls to .xlsx and then you could use EPPlus library.

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi Michael,

did you already verify what exact line in your code throws the error?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Michael,

Your coding looks like a customization. I would suggest to review the coding and check which exact statement is causing the error.

When looking at the screenshot, I think you want to import journal lines. Can't you use the standard features, like data import export framework or the Open in Excel functionality?

Was this reply helpful? Yes No
Michael Antony 314 on at

Like (0)

Report

Hi Nikolaos, when I try to debug the code,, I am not getting much information whereabout the error might happen (I included a screenshot on my main post). But I get error --> Exception thrown: 'System.IO.InvalidDataException' in EPPlus.dll

Was this reply helpful? Yes No
Michael Antony 314 on at

Like (0)

Report

Hi Andre, when I try to debug the code,, I am not getting much information whereabout the exact code that the error happen (I included a screenshot on my main post). But I get error --> Exception thrown: 'System.IO.InvalidDataException' in EPPlus.dll

What I need is to insert multiple Journal Header with each having Journal Lines, that's why I create a customized feature because such functionality is not supported in standard DIEF, isn't that correct Andre?

Was this reply helpful? Yes No
Michael Antony 314 on at

Like (0)

Report

Hi Will Wu,

Could you please give me a reference or example code to start working with Microsoft.Office.Interop.Excel to convert .xls?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Michael,

Please check:

stackoverflow.com/.../18904633

Was this reply helpful? Yes No