C# EPPLUS: Autosizing columns to the max autosize not working
C# EPPLUS: Autosizing columns to the max autosize not working I'm generating a number of excel documents with EPPlus and I'm running into some difficulties with the formatting. I have used xlWorkSheet.Cells.AutoFitColumns(); and this seems to work for the data, but does not autosize for the column names. For instance I will open up the file and I can see the column names bunched up. I can also click on the border of a column and it will expand the column more. In fact I can do this about 5 times before it seems to reach its maximum for autosizing. Essentially I want to programmatically set each column so that it's at this maximum (I've even tried applying AutoFitColumns multiple times, however this made no difference). Is there a way to do this? Note that I can't just hardcode the column widths as I'm trying to reuse the same code for multiple files. EDIT: Here's my code generalised private void GeneralTest() { var ReportName = "myReport" i...