//创建一个默认的DataTable
var dt = CreateDefaultDataTable();
//内存流
var m = new MemoryStream();
//设置为非商业用途,引入Epplus
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using var package = new ExcelPackage();
var worksheet = package.Workbook.Worksheets.Add("官方团报表");
worksheet.Cells.Style.Font.Size = 14;
worksheet.Cells[1, 1].Value = dt.Columns[0].ColumnName;
worksheet.Cells[1, 2].Value = dt.Columns[1].ColumnName;
for (int i = 0; i < dt.Rows.Count; i++)
{
worksheet.Cells[i + 2, 1].Value = dt.Rows[i][0];
worksheet.Cells[i + 2, 2].Value = dt.Rows[i][1];
}
//第而个参数代表Excel加密的密码
package.SaveAs(m, "123123");
//文件的数据
var data = m.ToArray();
C#如何将一个DataTable转换成Excel文件字节数组(无需创建文件)
最新推荐文章于 2024-05-23 15:31:43 发布