Comments by Gagandhiman (Top 2 by date)

Gagandhiman 18-Aug-10 2:42am View

Yes I have tried the same but the incorrect format file is coming when I tried to open the downloaded file.

can we do some other stuff like converting repeater data to XML format and then to load it in excel 2010 format.... what say? .. suggesty something

Gagandhiman 17-Aug-10 11:41am View

Hi Graus...

Thanks for reply. Code that i m using for excel 2003 and 2010 is listed below

Response.ClearHeaders()
Response.ContentEncoding = Encoding.GetEncoding("Windows-1252")
Response.Charset = ""
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ' '' for excel 2010

Response.ContentType ="application/vnd.ms-winword" '' for excel 2003

Response.AddHeader("content-disposition", "attachment; filename=RiskRatingExport.xlsx")

issue is that i m generating an repeater which is in table format and when open the repeater as excel by using code listed above for 2003 working fine and for 2010 excel it is showing incorect format of data.

Do I need to do something else.

Please reply it is urgent.

Thanks