when i convert datatable to .csv my excel sheets are generated as below: enter image description here

and tried like below:

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

then my excel sheets were like:

enter image description here

note that cells have =" " characters;

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

c# excel office-interop
Edit
Report