I am trying to find a way to auto-fit columns in Light Cells Data Provider.
Looking at the previous questions it is not supported due to the way Light Cells work (ref : Auto Fit Columns not working - #3 by toohotice)
Since that is an old answer, wanted to check again if it is supported now?
If not, what are the operations supported to set column width for cells in Light cells provider in ASP.Net, C#
We are afraid this feature cannot be supported in LightCells mode. Yes, as you know, it is because the way how LightCells works. To auto-fit rows and columns, all data needs to be filled and formatted for the whole row/column. But when output the column width and row height data, there is no cell data to measure the width and height.
You may set the column width and row height in the general way, such as SetColumnWidth and SetRowHeight before saving the workbook. Those settings will be output to the resultant file. But it is not possible to measure the width and height automatically by auto-fit. If you work with LightCells, maybe you need to measure them by your own logic according to the data you will fill into the cells and set them to corresponding rows and columns.
Okay. Thanks for the quick reply and suggestion.