There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Column AutoFit doesn't take AutoFilter size into consideration.
Just a small visual thing that I noticed (thank you OCD), if I am using AutoFilter, and then apply a column AutoFit, it doesn't take the size of the AutoFilter into consideration when applying the AutoFit size.
So in some columns the text will be covered by the AutoFilter, although re-applying an AutoFit once inside Excel will remedy the situation.
//Turn on the AutoFilter
workSheet.Cells[2, 1, 2, LastCell].AutoFilter = true;
for (var col = 1; col <= totalCols; col++)
BTW, I love this tool, my reports even look nicer than the ones people can generate using SAP Business Objects!