You can write out the data directly to the response stream. Set the mime type to excel and write the data out as :
- HTML
- CSV
- Spreadsheet XML
- OOXML (.xlsx)
If you want to use OOXML there are libraries such as Simple OOXML. Note this is the .xlsx format.
The following code sets the headers required for a .xls file
'Send response with content type to display as MS Excel
context.Response.Clear()
context.Response.Buffer = True
context.Response.AddHeader("content-disposition", String.Format( "attachment;filename={0}", fileName))
context.Response.ContentEncoding = Encoding.UTF8
context.Response.Cache.SetCacheability(HttpCacheability.Private)
context.Response.ContentType = "application/vnd.ms-excel"
'Write to response
context.Response.Write("csv,data,goes,here")
context.Response.End()
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…