C# 使用npoi导入excel 并使用xml做数据验证

上传者: changyuan2008 | 上传时间: 2021-07-23 16:46:36 | 文件大小: 2.88MB | 文件类型: RAR
VS2012创建项目,这个是使用C#语言npoi2.1.3.0导入excel到数据库中,同时使用了xml对excel的每个单元格数据进行了非空验证。经测试,导入成功。数据库写入部分请自己完成。有问题请留言。已经在项目中运中复杂多表头导入。

文件下载

资源详情

[{"title":"( 53 个子文件 2.88MB ) C# 使用npoi导入excel 并使用xml做数据验证","children":[{"title":"XlsImportDemo","children":[{"title":"bin","children":[{"title":"Debug","children":[{"title":"XlsImportDemo.vshost.exe.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"XlsImportDemo.exe <span style='color:#111;'> 18.50KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXml4Net.xml <span style='color:#111;'> 149.62KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"ICSharpCode.SharpZipLib.dll <span style='color:#111;'> 196.00KB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.xml <span style='color:#111;'> 410.62KB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.53MB </span>","children":null,"spread":false},{"title":"NPOI.OpenXmlFormats.dll <span style='color:#111;'> 1.79MB </span>","children":null,"spread":false},{"title":"NPOI.xml <span style='color:#111;'> 2.04MB </span>","children":null,"spread":false},{"title":"NPOI.OpenXml4Net.dll <span style='color:#111;'> 83.50KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.pdb <span style='color:#111;'> 53.50KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.vshost.exe <span style='color:#111;'> 22.45KB </span>","children":null,"spread":false},{"title":"user.xml <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.dll <span style='color:#111;'> 412.00KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.exe.config <span style='color:#111;'> 187B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"Form1.Designer.cs <span style='color:#111;'> 2.86KB </span>","children":null,"spread":false},{"title":"ParseConstans.cs <span style='color:#111;'> 693B </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 525B </span>","children":null,"spread":false},{"title":"BeanToMapUtil.cs <span style='color:#111;'> 3.44KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"XlsImportDemo.csprojResolveAssemblyReference.cache <span style='color:#111;'> 27.09KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"XlsImportDemo.exe <span style='color:#111;'> 18.50KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.19KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"XlsImportDemo.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.16KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.pdb <span style='color:#111;'> 53.50KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"XlsImportDemo.csproj.GenerateResource.Cache <span style='color:#111;'> 975B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"ParseXMLUtil.cs <span style='color:#111;'> 9.68KB </span>","children":null,"spread":false},{"title":"User.cs <span style='color:#111;'> 1.77KB </span>","children":null,"spread":false},{"title":"ParseExcelUtil.cs <span style='color:#111;'> 15.31KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"XlsImportDemo.csproj <span style='color:#111;'> 4.57KB </span>","children":null,"spread":false},{"title":"user.xml <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"user.xls <span style='color:#111;'> 32.50KB </span>","children":null,"spread":false},{"title":"DLL","children":[{"title":"NPOI.OpenXml4Net.XML <span style='color:#111;'> 149.62KB </span>","children":null,"spread":false},{"title":"ICSharpCode.SharpZipLib.dll <span style='color:#111;'> 196.00KB </span>","children":null,"spread":false},{"title":"NPOI.XML <span style='color:#111;'> 2.04MB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.53MB </span>","children":null,"spread":false},{"title":"NPOI.OpenXmlFormats.dll <span style='color:#111;'> 1.79MB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.XML <span style='color:#111;'> 410.62KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXml4Net.dll <span style='color:#111;'> 83.50KB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.dll <span style='color:#111;'> 412.00KB </span>","children":null,"spread":false}],"spread":false},{"title":"App.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"Resources.resx <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false},{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.81KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":true}]

评论信息

  • u010033022 :
    不错,确实可用,对于学习或是直接用都是不错!
    2019-01-03
  • penghaibing55 :
    看看还可以
    2018-06-09
  • chenlvbin123 :
    不错,确实可用,对于学习或是直接用都是不错!
    2017-07-03
  • shensi88 :
    思路还可以,代码有点乱
    2016-04-21
  • suzh0701 :
    不错可以学习下
    2015-12-23

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明