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.
Ps: Project is in .NET Core 3.1