MoneyTree.DataExport 数据导出

📋 概述

MoneyTree.DataExport 提供声明式数据导出能力，通过 [ExportColumn] 特性标记实体属性，自动生成 Excel（基于 ClosedXML）和 CSV 格式的导出文件。支持大数据量流式写入、自定义列格式化、列合计和进度回调。

🏗️ 项目文件结构

MoneyTree.DataExport/
├── MoneyTree.DataExport.csproj
├── GlobalUsings.cs
├── Abstractions/
│   └── IDataExporter.cs                 # 统一数据导出接口 + ExportFormat 枚举
├── Attributes/
│   └── ExportColumnAttribute.cs         # 导出列标记特性
├── Core/
│   ├── ExportOptions.cs                 # 全局配置选项
│   ├── ExportRequest.cs                 # 导出请求模型
│   ├── ExportResult.cs                  # 导出结果模型
│   ├── ExportColumnInfo.cs              # 导出列信息模型
│   └── ExportRow.cs                     # 导出数据行模型
├── Providers/
│   ├── ExcelExporter.cs                 # Excel 导出（ClosedXML）
│   └── CsvExporter.cs                   # CSV 导出
└── Extensions/
    ├── DataExportBuilder.cs             # 流畅配置构造器
    └── DataExportExtensions.cs          # DI 注册扩展

🎯 核心特性

🚀 快速开始

基础注册

// Program.cs
using MoneyTree.DataExport.Extensions;

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddMoneyTreeDataExport();

📖 使用示例

声明式导出

// 定义 DTO
public class OrderExportDto
{
    [ExportColumn("订单号", Order = 1, Width = 20)]
    public string OrderNumber { get; set; } = string.Empty;

    [ExportColumn("客户", Order = 2, Width = 15)]
    public string CustomerName { get; set; } = string.Empty;

    [ExportColumn("金额", Order = 3, Format = "¥#,##0.00", ShowSubtotal = true)]
    public decimal Amount { get; set; }

    [ExportColumn("状态", Order = 4)]
    public string Status { get; set; } = string.Empty;

    [ExportColumn("创建时间", Order = 5, Format = "yyyy-MM-dd HH:mm")]
    public DateTime CreatedAt { get; set; }

    [ExportColumn(Ignore = true)]    // 不导出
    public string InternalNote { get; set; } = string.Empty;
}

// 在服务中使用
[Inject] public IDataExporter Exporter { get; private set; } = default!;

public async Task<IResult> ExportOrdersAsync()
{
    var orders = await _db.Orders
        .Select(o => new OrderExportDto { /* 映射 */ })
        .ToListAsync();

    var bytes = await Exporter.ExportToBytesAsync(orders, new ExportRequest
    {
        Format = ExportFormat.Excel,
        Title = "订单列表",
        SheetName = "订单"
    });

    return Results.File(bytes,
        "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
        "订单列表.xlsx");
}

[ExportColumn] 特性参数

自定义列导出

不使用特性标记，通过代码动态指定导出列：

var bytes = await Exporter.ExportToBytesAsync(orders, new ExportRequest
{
    Format = ExportFormat.Excel,
    Title = "订单列表",
    Columns = new List<ExportColumnInfo>
    {
        new() { PropertyName = "OrderNumber", Title = "订单号", Order = 1 },
        new() { PropertyName = "Amount", Title = "金额", Order = 2, ShowSubtotal = true }
    }
});

CSV 导出

var bytes = await Exporter.ExportToBytesAsync(orders, new ExportRequest
{
    Format = ExportFormat.Csv,
    Title = "订单列表"
});

📊 导出格式对比