Posted 24 April 2023, 8:46 pm EST
I’m currently working on a project where I need to pass an array of data that will configure various settings in an Excel spreadsheet. I’m using Spreadsheet Gear with a .NET web API.
The idea is to have all the settings configured through this one array of data. This includes merged cells, cell styles, and any other configuration options that can be set in Excel.
I was wondering if anyone has any experience with this or could provide some guidance on how to approach it. It would be really helpful to have all the settings in one place for easy configuration.
Thanks in advance for any help you can provide!