Autosize column in Excel Sheet created at runtime

I am creating Excel Sheet at runtime. How can one re-size column width and apply color to header. Reference : http://www.codeproject.com/Articles/784342/Export-data-from-jqGrid-into-a-real-Excel-file