我有一段代码,没试过大量数据的时候行不行,你试试
Dim ms As New System.IO.MemoryStream
book.Write(ms)
Response.AddHeader("Content-Disposition", String.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")))
Response.BinaryWrite(ms.ToArray())
book = Nothing
ms.Close()
ms.Dispose()