Observe column K in the source excel file, upon passing the sheet through AutoFitColumns function the column width becomes extremely small (observe the output file).
I have attached the code, source excel file and the o…...Workbook(sourcePath); Worksheet sourceSheet = sourceWb.Worksheets[0]; AutoFitterOptions...AutoFitMergedCellsTy.EachLine; sourceWb.Worksheets[0].AutoFitColumns(4, 8, 40...