Hello,
I have a controller action where I can read an excel file, convert it to base64 send it to the front end, and decode it using a javascript function I found here on this forum.
However the problem arises when I make edits to the loaded excel through a library such as OpenXML/ClosedXML, etc... Sometimes the array size of the excel changes, sometimes it is the same but, no matter what the spreadsheet component CAN NOT read a file saved by either packages. They work fine when saved through normal excel.
Is there any way I can fix this? Maybe some other excel library I'm missing? The edits I need to do are fairly trivial. I'll just replace cell values, nothing more.
Thanks!
Ps: Project is in .NET Core 3.1