# XExcel

**Repository Path**: lipz89/xexcel

## Basic Information

- **Project Name**: XExcel
- **Description**: 通过NPOI处理excel，包含将列表数据，datatable，dataset数据类型转换为excel，包含从excel提取数据
- **Primary Language**: C#
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-01-09
- **Last Updated**: 2025-10-17

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# XExcel

#### 介绍
通过NPOI处理excel，包含将列表数据，datatable，dataset数据类型转换为excel，包含从excel提取数据

#### 使用说明

	1.     var list = ExcelHelper.LoadFromExcel<ImoprtRkdModel>(file, new Dictionary<string, Action<ImoprtRkdModel, IXCell>>() {
                { "供应商", (m, c) => m.GYSMC = c.GetValue<string>()?.Trim()},
                { "物资编码", (m, c) => m.WZBM = c.GetValue<string>()?.Trim()},
                { "生产日期", (m, c) => m.SCRQ = c.GetValue<DateTime?>()},
                { "生产批号", (m, c) => m.SCPH = c.GetValue<string>()?.Trim()},
                { "失效日期", (m, c) => m.SXRQ = c.GetValue<DateTime?>()},
                { "数量", (m, c) => m.SL = c.GetValue<decimal?>()},
                { "备注", (m, c) => m.BZ = c.GetValue<string>()?.Trim()},
                { "条形码", (m, c) => m.ZTM = c.GetValue<string>()?.Trim()},
                { "从条形码", (m, c) => m.CTM = c.GetValue<string>()?.Trim()},
                { "科室名称", (m, c) => m.KSMC = c.GetValue<string>()?.Trim()},
                { "库房名称", (m, c) => m.KFMC = c.GetValue<string>()?.Trim()},
            });

    2.      var sheet = ExcelHelper.LoadFromExcel<Yjkxx>(file, null, sheetIndex);
            sheet.Map(nameof(Yjkxx.WZBM), "物资编码", Validate.NotNull())
                .Map(nameof(Yjkxx.KFMC), "库房名称", Validate.NotNull())
                .Map(nameof(Yjkxx.KCXX), "库存下限", Validate.NotNull())
                .Map(nameof(Yjkxx.AQKC), "安全库存", Validate.NotNull())
                .Map(nameof(Yjkxx.KCSX), "库存上限", Validate.NotNull())
                .Map(nameof(Yjkxx.AutoEjkStr), "二级库配置是否统一")
                .Map(nameof(Yjkxx.EjkKCXX), "二级库库存下限")
                .Map(nameof(Yjkxx.EJkAQKC), "二级库安全库存")
                .Map(nameof(Yjkxx.EjkKCSX), "二级库库存上限")
                .Map(nameof(Yjkxx.EJkDS), "二级库定数")
                .Map(nameof(Yjkxx.HWXX), "货位信息")
                .Map(nameof(Yjkxx.GHXX), "供货目录")
                .Transfer();
            var yjkxxs = sheet.Rows.Select(x => x.Data).ToList();

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request