Net 按照列名的自定义顺序导出Excel

• 第一步

  • 定义导出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; }
  }

• 第二步

  • 在导出的Excel上面对应的model添加特性

  public class ExportModel
  {
      /// <summary>
      /// 宽度
      /// </summary>
      [ExportHeader("宽度", 1)]
      public decimal? Width { get; set; }
   
      /// <summary>
      /// 长度
      /// </summary>
      [ExportHeader("长度", 2)]
      public decimal? Length { get; set; }
   
      /// <summary>
      /// 数量
      /// </summary>
      [ExportHeader("数量",3)]
      public decimal? Count { get; set; }
   
      /// <summary>
      /// 重量
      /// </summary>
      [ExportHeader("重量", 4)]
      public decimal? Weight { get; set; }
  }

• 第三步

  • 获取导出的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();
   
   
   
  public class ColumnEntry
  {
      public PropertyInfo Property { get; set; }
      public ExportHeaderAttribute Header { get; set; }
  }

• 后面就是实际导出Excel的方法了，请自行参考