-
第一步
- 定义导出Excel的表头一个特性,继承自Attribute,包含列头的名字和列的顺序
public class ExportHeaderAttribute : Attribute { public ExportHeaderAttribute(string name) : this(name, -1) { } public ExportHeaderAttribute(string name, short order) { Name = name; Order = order; } /// <summary> /// 列名称 /// </summary> public string Name { get; } /// <summary> /// 列顺序 /// </summary> public short Order { get; } }
-
第二步
- 获取导出的model,并且按照特性排序
var properties = typeof(T).GetProperties(); var columns = properties.Select(x => new ColumnEntry { Property = x, Header = x.GetCustomAttribute<ExportHeaderAttribute>() }) .Where(x => x.Header != null) .OrderBy(x => x.Header.Order) .ToList();
-
后面就是实际导出Excel的方法了,请自行参考
Net 按照列名的自定义顺序导出Excel
发布时间 2023-12-23 14:45:19作者: EAGO