C# WinForm 利用NPOI 自定义[表头|列表|表尾]设计导出Execl格式源码【原创】【可直接运行】

上传者: a5562257 | 上传时间: 2025-06-06 21:46:43 | 文件大小: 4.6MB | 文件类型: RAR
C# WinForm 工作中遇到一个需要将界面表格数据按照设定的格式[表头|列表|表尾]导出到Excel文件,因为格式繁多一个个固定代码编写很不现实,网上找了很久都没有相关的功能实例,于是就加班自己动手写了一个通用的导出实例,已应用到代码中。现为方便广大开发者遍历特上传通用精简版分享给大家 如有优化建议和方向的同志可以加Q:398719557 一起交流学习进步 待解决问题: 1.界面设计时合并单元格问题(导出已合并)方便编辑模板 2.导出单元格背景色问题
完整版还有自动反射字段中文名称方便客户自己编辑 时间匆忙就懒得分离代码上传 了 原理很简单 字段自定义属性[PropertyDescriptor] 然后反射就好了

文件下载

资源详情

[{"title":"( 67 个子文件 4.6MB ) C# WinForm 利用NPOI 自定义[表头|列表|表尾]设计导出Execl格式源码【原创】【可直接运行】","children":[{"title":"ExcelDome","children":[{"title":"ExcelDome","children":[{"title":"Form1.Designer.cs <span style='color:#111;'> 11.14KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 489B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExcelDome.csproj.CopyComplete <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"ExcelDome.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"ExcelDome.csprojResolveAssemblyReference.cache <span style='color:#111;'> 66.13KB </span>","children":null,"spread":false},{"title":"ExcelDome.csproj.GenerateResource.cache <span style='color:#111;'> 1012B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 6.78KB </span>","children":null,"spread":false},{"title":"ExcelDome.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExcelDome.Dome.resources <span style='color:#111;'> 5.45KB </span>","children":null,"spread":false},{"title":"ExcelDome.pdb <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 864B </span>","children":null,"spread":false},{"title":"ExcelDome.csproj.CoreCompileInputs.cache <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"ExcelDome.exe <span style='color:#111;'> 22.00KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"bin","children":[{"title":"Release","children":null,"spread":false},{"title":"Debug","children":[{"title":"ExcelUtility.pdb <span style='color:#111;'> 69.50KB </span>","children":null,"spread":false},{"title":"ExcelTemplate","children":[{"title":"自定义[格式二].ETD <span style='color:#111;'> 1.76KB </span>","children":null,"spread":false},{"title":"自定义[格式一].ETD <span style='color:#111;'> 1.62KB </span>","children":null,"spread":false}],"spread":true},{"title":"NPOI.OpenXml4Net.dll <span style='color:#111;'> 89.00KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXmlFormats.dll <span style='color:#111;'> 2.02MB </span>","children":null,"spread":false},{"title":"NPOI.xml <span style='color:#111;'> 2.15MB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.60MB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.dll <span style='color:#111;'> 523.50KB </span>","children":null,"spread":false},{"title":"ExcelDome.pdb <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false},{"title":"ExcelUtility.dll <span style='color:#111;'> 69.50KB </span>","children":null,"spread":false},{"title":"ExcelDome.exe <span style='color:#111;'> 22.00KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"ExcelDome.csproj <span style='color:#111;'> 3.52KB </span>","children":null,"spread":false},{"title":"Demo.cs <span style='color:#111;'> 4.81KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 14.52KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.29KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"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":"Resources.Designer.cs <span style='color:#111;'> 2.76KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"ExcelUtility","children":[{"title":"ExcelTemplateDesign.Designer.cs <span style='color:#111;'> 33.91KB </span>","children":null,"spread":false},{"title":"UtilConvert.cs <span style='color:#111;'> 10.80KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExcelUtility.pdb <span style='color:#111;'> 69.50KB </span>","children":null,"spread":false},{"title":"ExcelUtility.csproj.GenerateResource.cache <span style='color:#111;'> 953B </span>","children":null,"spread":false},{"title":"ExcelUtility.csprojResolveAssemblyReference.cache <span style='color:#111;'> 88.07KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 6.92KB </span>","children":null,"spread":false},{"title":"ExcelUtility.csproj.CopyComplete <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExcelUtility.ExcelTemplateDesign.resources <span style='color:#111;'> 27.79KB </span>","children":null,"spread":false},{"title":"ExcelUtility.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"ExcelUtility.csproj.CoreCompileInputs.cache <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"ExcelUtility.dll <span style='color:#111;'> 69.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"Release","children":[{"title":"NPOI.OpenXml4Net.dll <span style='color:#111;'> 89.00KB </span>","children":null,"spread":false},{"title":"NPOI.Extend.dll <span style='color:#111;'> 20.50KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXmlFormats.dll <span style='color:#111;'> 2.02MB </span>","children":null,"spread":false},{"title":"NPOI.xml <span style='color:#111;'> 2.15MB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.60MB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.dll <span style='color:#111;'> 523.50KB </span>","children":null,"spread":false}],"spread":true},{"title":"Debug","children":[{"title":"ExcelUtility.pdb <span style='color:#111;'> 69.50KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXml4Net.dll <span style='color:#111;'> 89.00KB </span>","children":null,"spread":false},{"title":"NPOI.Extend.dll <span style='color:#111;'> 20.50KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXmlFormats.dll <span style='color:#111;'> 2.02MB </span>","children":null,"spread":false},{"title":"NPOI.xml <span style='color:#111;'> 2.15MB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.60MB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.dll <span style='color:#111;'> 523.50KB </span>","children":null,"spread":false},{"title":"ExcelUtility.dll <span style='color:#111;'> 69.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"ExcelTemplateDesign.resx <span style='color:#111;'> 45.47KB </span>","children":null,"spread":false},{"title":"ExcelTemplateDesign.cs <span style='color:#111;'> 29.99KB </span>","children":null,"spread":false},{"title":"RbwExport.cs <span style='color:#111;'> 17.17KB </span>","children":null,"spread":false},{"title":"ExcelUtility.csproj <span style='color:#111;'> 3.83KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false}],"spread":true},{"title":"ExcelUtility.csproj.user <span style='color:#111;'> 228B </span>","children":null,"spread":false}],"spread":true},{"title":".vs","children":[{"title":"ExcelDome","children":[{"title":"v15","children":[{"title":".suo <span style='color:#111;'> 64.00KB </span>","children":null,"spread":false},{"title":"Server","children":[{"title":"sqlite3","children":[{"title":"storage.ide <span style='color:#111;'> 856.00KB </span>","children":null,"spread":false},{"title":"db.lock <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"ExcelDome.sln <span style='color:#111;'> 1.58KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

免责申明

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