Click Button to Export Excel Asp.net C#

浏览数：32 / 时间：2015年06月09日

public 
void ExportExcel(string 
excelLocation)
{
    FileStream fs = null;
    try
    {
        fs = File.OpenRead(excelLocation);
        Byte[] fileBytes = new 
byte[fs.Length];
        fs.Read(fileBytes, 0, Convert.ToInt32(fs.Length));
        //Clear the response               
        Response.Clear();
        Response.ClearContent();
        Response.ClearHeaders();
        Response.Cookies.Clear();
        //Add the header & other information      
        Response.Cache.SetCacheability(System.Web.HttpCacheability.Private);
        Response.CacheControl = "private";
        Response.Charset = System.Text.UTF8Encoding.UTF8.WebName;
        Response.ContentEncoding = System.Text.UTF8Encoding.UTF8;
        Response.AppendHeader("Content-Length", fileBytes.Length.ToString());
        Response.AppendHeader("Pragma", "cache");
        Response.AppendHeader("Expires", "60");
        Response.AppendHeader("Content-Disposition",
        "attachment; " 
+
        "filename=\"ExcelReport.xlsx\"; " 
+
        "size=" 
+ fileBytes.Length.ToString() + "; " 
+
        "creation-date=" 
+ DateTime.Now.ToString("R") + "; " 
+
        "modification-date=" 
+ DateTime.Now.ToString("R") + "; " 
+
        "read-date=" 
+ DateTime.Now.ToString("R"));
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
        //Write it back to the client    
        Response.BinaryWrite(fileBytes);
        Response.End();
    }
    finally
    {
        if 
(fs != null)
        {
            fs.Close();
            fs.Dispose();
        }
    }
}