MiniExcel的使用

Install-Package MiniExcel

var items = MiniExcel.Query<ConnectorChannelInfo>(fileName);

MiniExcel.SaveAs(fileName, items, true, "Sheet1", ExcelType.XLSX, null, true);

[ExcelColumnName("优先级")]
public EProjectLevel ProjectLevel { get; set; }

[ExcelColumnName("创建时间")]
[ExcelFormat("yyyy年M月d日")]
public DateTime CreateTime { get; set; }

[ExcelIgnore]
public string ProjectGuid { get; set; }