C# 将数据导出到EXCEL表格，简单布局

最新推荐文章于 2024-10-02 20:15:56 发布

juncaixingchilove

最新推荐文章于 2024-10-02 20:15:56 发布

阅读量118

点赞数 1

文章标签： c# excel

本文链接：https://blog.csdn.net/juncaixingchilove/article/details/142630317

版权

可以设置页面标题，列标题，设置列宽，设置居中方式，详情见代码

//传入路径+文件名称，datatable数据 
public void outexcel(string filepath, DataTable dt)
 {
     //设置新建文件路径及名称
     string savePath = filepath + "";
     ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
     // 创建一个Excel文件
     using (var package = new ExcelPackage(new FileInfo(savePath)))
     {

         // 添加一个新的工作表
         var worksheet = package.Workbook.Worksheets.Add("Sheet1");
         worksheet.Columns[2].Width = 22.5;
         worksheet.Columns[3].Width = 50;
         worksheet.Columns[4].Width = 25;
         // 设置第一行的字体为宋体，字号为12
         //设置抬头
         worksheet.Cells[1, 3].Style.Font.Name = "隶书";
         worksheet.Cells[1, 3].Style.Font.Size = 18;
         worksheet.Cells[1, 3].Style.Font.Bold = true;
         worksheet.Cells[1, 3].Value = "系统运行日志";
         worksheet.Cells[1, 3].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

         worksheet.Cells[2, 2].Style.Font.Name = "宋体";
         worksheet.Cells[2, 2].Style.Font.Size = 12;
         worksheet.Cells[2, 2].Value = "数据编号";
         worksheet.Cells[2, 2].Style.Font.Bold = true;
         worksheet.Cells[2, 2].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

         worksheet.Cells[2, 3].Style.Font.Name = "宋体";
         worksheet.Cells[2, 3].Style.Font.Size = 12;
         worksheet.Cells[2, 3].Value = "数据内容";
         worksheet.Cells[2, 3].Style.Font.Bold = true;
         worksheet.Cells[2, 3].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

         worksheet.Cells[2, 4].Style.Font.Name = "宋体";
         worksheet.Cells[2, 4].Style.Font.Size = 12;
         worksheet.Cells[2, 4].Value = "数据时间";
         worksheet.Cells[2, 4].Style.Font.Bold = true;
         worksheet.Cells[2, 4].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

         for (int i = 0; i < dt.Rows.Count; i++)
         {
             for (int j = 0; j < dt.Columns.Count; j++)
             {
                 worksheet.Cells[i + 3, j + 2].Value = dt.Rows[i][j].ToString();
                 worksheet.Cells[i + 3, j + 2].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
             }
         }
         package.Save();
     }
 }