Common/Gardener.Common/Excel/ExcelHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using MiniExcelLibs;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;

namespace Gardener.Common;

// TODO: 其他项目应该统一从这里引用MiniExcel, 避免包的版本不同报错
// TODO2：这个库应该是全局基础库，几乎所有的包都应该在这里引用
// 或者Gardener作为全局基础库
// TODO3: Common库里面要不要输出log
//https://gitee.com/dotnetchina/MiniExcel?_from=gitee_search#https://gitee.com/link?target=https%3A%2F%2Fdotnetfiddle.net%2Fw5WD1J

/// <summary>
/// Excel 工具类
/// </summary>
public class ExcelHelper
{
    /// <summary>
    /// 扩展名称
    /// </summary>
    public static string Extension = ".xlsx";

    #region Read Excel
    /// <summary>
    /// 读取Excel
    /// </summary>
    /// <param name="path"></param>
    /// <param name="hasHeader"></param>
    /// <returns></returns>
    [Obsolete("注意：大数据量加载时可能占用大量内存")]
    public static async Task<DataTable> GetDataTableAsync(string path, bool hasHeader = true)
    {
        //todo:已过时，需处理
        var table = await MiniExcel.QueryAsDataTableAsync(path, hasHeader);
        return table;

        // 如果导入数据时用的是GetDataTable方法，dataTable转Class如果碰到数字转换的问题，可以用这个方法
        // 将数值统一换成string
        //Change value to string for SqlSugar or other tools to get a Entity list from DataTable
        //, since double to int could cause error
        //var newTable = ChangeValueToString(table);
        //return newTable;
    }
    /// <summary>
    /// 读取
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="path"></param>
    /// <param name="sheetName"></param>
    /// <param name="excelType"></param>
    /// <param name="startCell"></param>
    /// <param name="configuration"></param>
    /// <param name="cancellationToken"></param>
    /// <returns></returns>
    public static async Task<List<T>> GetListAsync<T>(string path, string? sheetName = null, ExcelType excelType = ExcelType.UNKNOWN, string? startCell = "A1", IConfiguration? configuration = null, CancellationToken cancellationToken = default(CancellationToken)) where T : class, new()
    {