I've been using LargeXlsx .Net library to generate big spreadsheets with ease for some time, also in order to comply with a no-office-on-servers policy. But now, we have a new report with a fancy requirement which demands the output files with the grid lines hidden, I now it's pointless but still mandatory anyway. Unfortunately, LargeXlsx doesn't support such a setting so now I'm turning to the OpenXML SDK just to get this done. Most of the info on the Web is set around creating a new spreadsheet document from scratch and despite trying to extract what I need for my case, I can't just get it right and always end up with "corrupted file" like messages from Excel.
What I want to do is simply open the spreadsheet file, set the "hidden grid lines", save and close by using OpenXML SDK.
- Framework: ASPNET with NET Framework 4.8
- Language: Visual Basic
Any help is greatly appreciated.