IExcelSugarClient excelSugarClient = new ExcelSugarClient(new ExcelSugarConfig { Path = "../../../TempExcel/Test.xlsx", HandlerType = ExcelHandlerType.Npoi });

    [SugarSheet("测试表")]
    public class TestModel
    {
        [SugarHead("姓名")]
        public string Name { get; set; }
        [SugarHead("描述")]
        public string Description { get; set; }

        /// <summary>
        /// 导出可支持动态列模型
        /// </summary>
        [SugarDynamicHead]
        public List<DynamicModel> DynamicModels { get; set; } = new List<DynamicModel>();

        [SugarHead("字典列", IsJson = true)]
        public Dictionary<int, string> Dic { get; set; } = new Dictionary<int, string>();

        [SugarHead("对象列", IsJson = true)]

        public ObjectModel ObjectModel { get; set; } = new ObjectModel();
    }
    /// <summary>
    /// 动态表头，需具备IsCode、IsValue、IsName 3个字段
    /// </summary>
    public class DynamicModel
    {
        [SugarDynamicHead(IsCode = true)]
        public string DataCode { get; set; }

        [SugarDynamicHead(IsValue = true)]
        public int DataValue { get; set; }

        [SugarDynamicHead(IsName = true)]
        public string DataName { get; set; }
    }


    public class ObjectModel
    {
        public string Test1 { get; set; }
        public int Test2 { get; set; }
        public List<string> Test3 { get; set; } = new List<string>();
        public List<int> Test4 { get; set; }
    }

//创建实体
var testModel = new List<TestModel> {
                new TestModel { Description = "男的", Name = "张三",
                    Dic=new Dictionary<int, string>{ { 10,"OK"},{20,"NO" } },
                    ObjectModel=new ObjectModel{ Test1="1",Test2=2,Test3=new List<string>{ "1","2","3"},Test4=new List<int>{ 6,7,8,9} },
                    DynamicModels = new List<DynamicModel>{
                        new DynamicModel { DataCode="height",DataName="身高",DataValue=188},
                } },
                new TestModel { Description = "女的", Name = "李四",
                    ObjectModel=new ObjectModel{ Test1="11",Test2=222,Test3=new List<string>{ "11","22","33"},Test4=new List<int>{ 66,77,88,99} },
                    DynamicModels=new List<DynamicModel>{
                        new DynamicModel { DataCode="height",DataName="身高",DataValue=168},
                        new DynamicModel { DataCode="age",DataName="年龄",DataValue=18},
                } }
            };



//从excel中查询出实体
var data = await client.Queryable<TestModel>().ToListAsync();

//从excel中查询出实体，支持where表达式
var data = await client.Queryable<TestModel>().Where(x => x.Name == "张三").ToListAsync();

//将实体直接导出excel
await client.Exportable(testModel).ExecuteCommandAsync();

//将实体根据给定的模板进行导出excel
await client.Exportable(testModel).From("../../../TempExcel/Template.xlsx").ExecuteCommandAsync();
//Or await client.Exportable("../../../Test.xlsx").ExecuteCommandAsync();