HcfNS.Office 7.0.2.2

Hcf Office 组件，封装基于Office操作的实现

用法

通过nuget引用 Hcf.Office 程序集

Install-Package HcfNS.Office

添加 OfficePack 组件包

services.AddPack<OfficePack>();

示例

导出Excel

IExcelWriter _excelWriter=provider.GetService<IExcelWriter>();//获取ExcelWriter实例

int count = 5;
string[] fields = new[]
{
    "Column1","Column2","Column3","Column4","Column5"
};
string[] headers = new[]
{
    "列1","列2","列3","列4","列5"
};

List<TestInfo> tests = new List<TestInfo>();
for(int i = 0; i < 20000; i++)
{
    tests.Add(new TestInfo
    {
        Column1 = "Column1_" + i.ToString(),
        Column2 = "Column2_" + i.ToString(),
        Column3 = i,
        Column4 = i,
        Column5 = "Column5_" + i.ToString()
    });
}

List<TestInfo> tests1 = new List<TestInfo>();
for (int i = 20000; i < 60000; i++)
{
    tests1.Add(new TestInfo
    {
        Column1 = "Column1_" + i.ToString(),
        Column2 = "Column2_" + i.ToString(),
        Column3 = i,
        Column4 = i,
        Column5 = "Column5_" + i.ToString()
    });
}

_excelWriter.StartWrite();
_excelWriter.WriteTitle("测试Excel导出标题", count);
_excelWriter.WriteHeader(headers);
_excelWriter.WriteData(tests, fields);
_excelWriter.WriteData(tests1, fields);
byte[] bytes = _excelWriter.GetExcelBytes();
_excelWriter.Close();