how to set xls font size from Response

[aajaydee]

I am using this to transfer data from asp page to excel sheet.

Response.AddHeader("Content-Disposition", "attachment; filename=" + ExportReportName)
Response.AddHeader("Content-Length", bytes.Length.ToString())
Response.ContentType = "application/octet-stream"
Response.BinaryWrite(bytes)
Response.End()

every thing is working fine I just need to set the font size for XLS spread sheed
How can I set xls spread sheet font from this code

Any help will be help full

 

[tperri]

You need to apply your style to the text before you put it into your bytes array.

I dont know what your source is, but here is a decent article that shows you how to do some formatting for an excel export.

http://www.gridviewguy.com/ArticleDetails.aspx?articleID=197