Hi,
I am working on a project which needs to auto fit all of the columns in all rows except first 3 rows. Do you know how to do it?
Thanks,
Lucy
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputfile);
Worksheet sheet = workbook.Worksheets[0];
//autofitcloumn from the second column
var destRange = sheet.Range[sheet.FirstRow, 2, sheet.LastRow, sheet.LastColumn];
destRange.AutoFitColumns();