excel

  protected void ExcelBt_Click(object sender, EventArgs e)
    {
        List<GPSInfo> list = Session["gisHisData"] as List<GPSInfo>;
        if (list != null && list.Count > 0)
        {
            ExcelEdit edit = new ExcelEdit();
            edit.CreateExcel();
            edit.WriteHisData( list, 0, list.Count - 1 );
            Random rand = new Random();
            string fileName = Server.MapPath( "." ) + "/HistoryGps_" + rand.Next( 10 ).ToString() + ".xls";
            edit.ExplortExcel( fileName );
            Session.Remove( "gisHisData" );
            ImportExcel( fileName, edit );
        }
    }
    public void ImportExcel(string fileName, ExcelEdit exelTools)
    {
        exelTools.deleteTempExcel();
        System.IO.FileInfo file = new System.IO.FileInfo( fileName );
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        // 添加头信息，为"文件下载/另存为"对话框指定默认文件名
        Response.AddHeader( "Content-Disposition", "attachment; filename=" + Server.UrlEncode( file.Name ) );
        // 添加头信息，指定文件大小，让浏览器能够显示下载进度
        Response.AddHeader( "Content-Length", file.Length.ToString() );

        // 指定返回的是一个不能被客户端读取的流，必须被下载
        Response.ContentType = "application/ms-excel";

        // 把文件流发送到客户端
        Response.WriteFile( file.FullName );
        // 停止页面的执行
        Response.Flush();
        file.Delete();
        Response.End();
    }/Files/labliang/ExcelEdit.rar