Magicodes.ExporterAndImporter 导出csv文件

实战：导出csv文件了，项目中引入以下nuget包

 

 

导出实体

  /// <summary>
    /// XX查询
    /// </summary>
    /// <remarks></remarks>
    [Exporter(Name = "XX查询", AutoFitAllColumn = true)]
    public class Report
    {
        [ExporterHeader(IsIgnore = true)]
        public string Id { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [ExporterHeader(DisplayName = "日期", Format = "yyyy-MM-dd HH:mm:ss")]
        public System.DateTime? CreateDate { get; set; }     

        [ExporterHeader(IsIgnore = true)]
        public DateTime UpdateDate { get; set; }

        [ExporterHeader(DisplayName = "数量")]
        public decimal shl { get; set; }
        [ExporterHeader(DisplayName = "单价")]
        public decimal Price { get; set; }
     
    }

导出文件

var dirPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "downloadTemp");

 if (!Directory.Exists(dirPath))
 Directory.CreateDirectory(dirPath);

string name = $"xxxxxxx.csv"
var file = Path.Combine(dirPath, name);
var exportFilePath = new Magicodes.ExporterAndImporter.Csv.CsvExporter().Export<Report>(file, result).Result;

 if (!File.Exists(exportFilePath.FileName))
 return new ResponseModel("99", "导出文件异常");

 fileName = $"/downloadTemp/{name}";