Sir,

I was using this UR http://www.aspsnippets.com/Articles/Export-GridView-Data-to-Excel-using-OpenXml-in-ASPNet.aspx, for exporting the data to excel. Can I do the following two things while exporting:

1) I want to remove the autofilter options, which are displaying now when you open the excel workbook soon after exporting finishes.

2) Some of the columns which are numerics, are formatted to text by default, and it is displaying a small green rectangular icon at the left top corner of each cell which is very disturbing while viewing the sheet.

Is it possible to fix both the above options. Please suggest.

Thanks,

Rajaraman.