C#实现从数据库数据批量导出Excel.zip

[{"title":"（ 75 个子文件 1.82MB ） C#实现从数据库数据批量导出Excel.zip","children":[{"title":"桌面","children":[{"title":"rm.txt <span style='color:#111;'> 73B </span>","children":null,"spread":false},{"title":"1.NPOI测试","children":[{"title":"NPOI测试","children":[{"title":"Form1.Designer.cs <span style='color:#111;'> 4.53KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 491B </span>","children":null,"spread":false},{"title":"NPOI测试.csproj <span style='color:#111;'> 4.27KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"NPOI测试.csproj.FileListAbsolute.txt <span style='color:#111;'> 2.18KB </span>","children":null,"spread":false},{"title":"NPOI测试.csproj.GenerateResource.Cache <span style='color:#111;'> 847B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"NPOI测试.pdb <span style='color:#111;'> 29.50KB </span>","children":null,"spread":false},{"title":"NPOI测试.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"NPOI测试.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"NPOI测试.exe <span style='color:#111;'> 13.00KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"Debug","children":[{"title":"NPOI测试.vshost.exe <span style='color:#111;'> 13.99KB </span>","children":null,"spread":false},{"title":"Ionic.Zip.dll <span style='color:#111;'> 435.00KB </span>","children":null,"spread":false},{"title":"NPOI测试.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.20MB </span>","children":null,"spread":false},{"title":"NPOI测试.pdb <span style='color:#111;'> 29.50KB </span>","children":null,"spread":false},{"title":"NPOI测试.exe <span style='color:#111;'> 13.00KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 7.01KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.88KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.34KB </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.80KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"NPOI测试.sln <span style='color:#111;'> 920B </span>","children":null,"spread":false},{"title":"NPOI测试.suo <span style='color:#111;'> 15.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"3.使用Io类导入内容到excel","children":[{"title":"WindowsFormsApplication3","children":[{"title":"WindowsFormsApplication3.sln <span style='color:#111;'> 962B </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.suo <span style='color:#111;'> 17.50KB </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3","children":[{"title":"WindowsFormsApplication3.csproj <span style='color:#111;'> 3.71KB </span>","children":null,"spread":false},{"title":"Form1.Designer.cs <span style='color:#111;'> 4.10KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 505B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"WindowsFormsApplication3.exe <span style='color:#111;'> 15.50KB </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.csproj.FileListAbsolute.txt <span style='color:#111;'> 3.60KB </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"WindowsFormsApplication3.csproj.GenerateResource.Cache <span style='color:#111;'> 847B </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.pdb <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"Debug","children":[{"title":"WindowsFormsApplication3.exe <span style='color:#111;'> 15.50KB </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.vshost.exe <span style='color:#111;'> 13.99KB </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"WindowsFormsApplication3.pdb <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 6.05KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.88KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.08KB </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.83KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"2.OperateExcel","children":[{"title":"OperateExcel.suo <span style='color:#111;'> 15.50KB </span>","children":null,"spread":false},{"title":"OperateExcel","children":[{"title":"Form1.Designer.cs <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 493B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"OperateExcel.pdb <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false},{"title":"OperateExcel.csproj.GenerateResource.Cache <span style='color:#111;'> 847B </span>","children":null,"spread":false},{"title":"OperateExcel.csproj.FileListAbsolute.txt <span style='color:#111;'> 2.43KB </span>","children":null,"spread":false},{"title":"ResolveAssemblyReference.cache <span style='color:#111;'> 10.77KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"OperateExcel.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"Refactor","children":null,"spread":false},{"title":"OperateExcel.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"OperateExcel.exe <span style='color:#111;'> 10.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"Debug","children":[{"title":"office.dll <span style='color:#111;'> 437.85KB </span>","children":null,"spread":false},{"title":"OperateExcel.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"OperateExcel.pdb <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Interop.Excel.xml <span style='color:#111;'> 3.41MB </span>","children":null,"spread":false},{"title":"OperateExcel.vshost.exe <span style='color:#111;'> 13.99KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Interop.Excel.dll <span style='color:#111;'> 1.48MB </span>","children":null,"spread":false},{"title":"Microsoft.Vbe.Interop.dll <span style='color:#111;'> 61.85KB </span>","children":null,"spread":false},{"title":"OperateExcel.exe <span style='color:#111;'> 10.50KB </span>","children":null,"spread":false},{"title":"office.xml <span style='color:#111;'> 1.06MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 5.88KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"OperateExcel.csproj <span style='color:#111;'> 3.85KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.34KB </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.81KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"OperateExcel.sln <span style='color:#111;'> 926B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]