programmatically excel cells to be auto fit width & height

Question

when i convert datatable to .csv my excel sheets are generated as below:

and tried like below:

sw.Write(string.Format("=\"{0}\"", drow[i].ToString()));

then my excel sheets were like:

note that cells have =" " characters;

i'm trying to do like auto fit width & height of each cells programmatically. How?

Answer 1

Try getting the range and then do Autofit

Range.Rows.AutoFit();
Range.Columns.AutoFit();