DataTable dataTable = ExcelHelper.ExcelImport(filePath);
RemoveEmpty(dataTable);//去除空格
//部门
DataTable DepartTable = userBLL.GetDataTable();
//公司
DataTable OrganizeTable = userBLL.GetOrganizeTable();
//DataTable distinctTable = null;
DataView view = new DataView(dataTable);
DataTable data = view.ToTable(true, new string[] { "账户", "姓名", "性别", "公司", "部门", "手机", "电话", "出生日期", "邮箱", "身份证号", "地址", "警号", "人员类型名称" });
//if (dataTable!=null&&dataTable.Rows.Count>0)
//{
// string[] columnNames = GetTableColumnName(dataTable);
// DataView dataVie
NPOI导入Excel数据 筛选Excel重复数据做出提示 求大神指教
最新推荐文章于 2024-01-14 14:20:21 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)