下载excel格式的数据_excel数据下载-优快云博客

该代码段展示了一个方法，用于将System.Data.DataTable对象的数据转换成Excel格式，并保存到指定的文件中。它创建一个新的Excel包，填充列名，然后遍历DataTable的每一行数据，将其内容写入Excel工作表。最后，设置响应头以触发文件下载。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 public static void DataTable2ExcelNew(System.Data.DataTable dtData, string fileName)
        {
             
            string sheetName = "Sheet1";
//descFile 给一个模板的文件用来存储列名 例如示范 在桌面创建一个111的xlsx文件
            string descFile = "C:\\Desktop\\111.xlsx";
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            FileInfo fileinfo = new FileInfo(descFile);
            ExcelPackage excel = new ExcelPackage(fileinfo);
            ExcelWorksheet sheet = excel.Workbook.Worksheets[sheetName];
            DataTable dt = dtData;
            int row = dt.Rows.Count;    //行 
            sheet.Cells[1, 1].Value = "区域";
            sheet.Cells[1, 2].Value = "产品名称";
            sheet.Cells[1, 3].Value = "规格";
            sheet.Cells[1, 4].Value = "型号";
            sheet.Cells[1, 5].Value = "厂家";
            sheet.Cells[1, 6].Value = "供应商";
            sheet.Cells[1, 7].Value = "单价";
            sheet.Cells[1, 8].Value = "单位";
            sheet.Cells[1, 9].Value = "采购描述";
            sheet.Cells[1, 10].Value ="数据来源"; 
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                sheet.Cells[i + 2, 1].Value = dt.Rows[i]["区域"];
                sheet.Cells[i + 2, 2].Value = dt.Rows[i]["产品名称"];
                sheet.Cells[i + 2, 3].Value = dt.Rows[i]["规格"];
                sheet.Cells[i + 2, 4].Value = dt.Rows[i]["型号"];
                sheet.Cells[i + 2, 5].Value = dt.Rows[i]["厂家"];
                sheet.Cells[i + 2, 6].Value = dt.Rows[i]["供应商"];
                sheet.Cells[i + 2, 7].Value = dt.Rows[i]["单价"];
                sheet.Cells[i + 2, 8].Value = dt.Rows[i]["单位"];
                sheet.Cells[i + 2, 9].Value = dt.Rows[i]["采购描述"];
                sheet.Cells[i + 2, 10].Value = dt.Rows[i]["数据来源"]; 
            }
            byte[] b = excel.GetAsByteArray();
            HttpContext curContext = System.Web.HttpContext.Current;
            // curContext.Response.ContentType = "application/vnd.ms-excel";
            curContext.Response.ContentType = "text/plain";//Content-Disposition
            // curContext.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            curContext.Response.AddHeader("content-disposition", "attachment;  filename="+ fileName + ".xlsx");
            curContext.Response.Charset = "gb2312";  //必须写，否则会有乱码
            curContext.Response.ContentEncoding = System.Text.Encoding.UTF7;  //必须写，否则会有乱码

            curContext.Response.AddHeader("Content-Length", b.Length.ToString());
            curContext.Response.BinaryWrite(b);
            curContext.Response.End();
        }