First, I am new to using this product so there’s a good chance that I’m probably not doing something that I need to do so I’m hoping someone can tell me what I might be doing wrong. I’m using C# in VS2022 .Net Core 6. I installed the GemBox.Spreadsheet component via a NuGet package. I am currently using the free version.
I am trying to create a spreadsheet with data from a database but I am unable to set the column widths. In trying to debug my app I’ve been able to find that for some reason after adding data in 238 cells in row 0 (this would be for column headings), the number of columns returned in worksheet.Columns.Count is always equal to 0. The spreadsheet that gets generated with a total of 6 rows and 238 columns ends up having column widths that are absurdly wide when I open the spreadsheet in Excel.
Thank you in advance for any assistance anyone is able to provide.