使用NPOI做的一个动态导出多个sheet的excel,同时将其转成二进制存入数据库,以链接的方式下载excel。

上传者: jws873176893 | 上传时间: 2022-05-13 17:56:58 | 文件大小: 4.26MB | 文件类型: RAR
使用NPOI做的一个动态导出多个sheet的excel,同时将其转成二进制存入数据库,以链接的方式下载excel。就相当于将excel不导出到服务器上而是将excel以二进制的形式存进数据库中。在将二进制读出来,生成一个链接 供用户下载。

文件下载

资源详情

[{"title":"( 79 个子文件 4.26MB ) 使用NPOI做的一个动态导出多个sheet的excel,同时将其转成二进制存入数据库,以链接的方式下载excel。","children":[{"title":"WebApplication1","children":[{"title":"WebApplication1.suo <span style='color:#111;'> 33.00KB </span>","children":null,"spread":false},{"title":"bin","children":[{"title":".net 4.0","children":[{"title":"NPOI.XML <span style='color:#111;'> 1.92MB </span>","children":null,"spread":false},{"title":"Ionic.Zip.dll <span style='color:#111;'> 435.00KB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.38MB </span>","children":null,"spread":false}],"spread":true},{"title":".net 2.0","children":[{"title":"NPOI.XML <span style='color:#111;'> 1.92MB </span>","children":null,"spread":false},{"title":"Ionic.Zip.dll <span style='color:#111;'> 435.00KB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.39MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"ConsoleApplication1","children":[{"title":"bin","children":[{"title":"Debug","children":[{"title":"ConsoleApplication1.exe <span style='color:#111;'> 6.50KB </span>","children":null,"spread":false},{"title":"ConsoleApplication1.pdb <span style='color:#111;'> 11.50KB </span>","children":null,"spread":false},{"title":"ConsoleApplication1.vshost.exe <span style='color:#111;'> 11.33KB </span>","children":null,"spread":false},{"title":"ConsoleApplication1.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Program.cs <span style='color:#111;'> 2.39KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"x86","children":[{"title":"Debug","children":[{"title":"ConsoleApplication1.exe <span style='color:#111;'> 6.50KB </span>","children":null,"spread":false},{"title":"ConsoleApplication1.pdb <span style='color:#111;'> 11.50KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 5.66KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ConsoleApplication1.csproj.FileListAbsolute.txt <span style='color:#111;'> 429B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"ConsoleApplication1.csproj <span style='color:#111;'> 2.40KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"WebApplication1","children":[{"title":"StuClass.cs <span style='color:#111;'> 1.54KB </span>","children":null,"spread":false},{"title":"WebForm1.aspx <span style='color:#111;'> 1.76KB </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"WebApplication1.dll <span style='color:#111;'> 16.50KB </span>","children":null,"spread":false},{"title":"Ionic.Zip.dll <span style='color:#111;'> 435.00KB </span>","children":null,"spread":false},{"title":"WebApplication1.pdb <span style='color:#111;'> 57.50KB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.38MB </span>","children":null,"spread":false},{"title":"NPOI.xml <span style='color:#111;'> 1.92MB </span>","children":null,"spread":false}],"spread":true},{"title":"Site.Master.cs <span style='color:#111;'> 347B </span>","children":null,"spread":false},{"title":"Default.aspx <span style='color:#111;'> 765B </span>","children":null,"spread":false},{"title":"Account","children":[{"title":"ChangePassword.aspx.cs <span style='color:#111;'> 353B </span>","children":null,"spread":false},{"title":"Register.aspx <span style='color:#111;'> 5.57KB </span>","children":null,"spread":false},{"title":"ChangePassword.aspx.designer.cs <span style='color:#111;'> 843B </span>","children":null,"spread":false},{"title":"Web.config <span style='color:#111;'> 347B </span>","children":null,"spread":false},{"title":"Register.aspx.cs <span style='color:#111;'> 915B </span>","children":null,"spread":false},{"title":"ChangePasswordSuccess.aspx.cs <span style='color:#111;'> 360B </span>","children":null,"spread":false},{"title":"ChangePasswordSuccess.aspx <span style='color:#111;'> 512B </span>","children":null,"spread":false},{"title":"ChangePasswordSuccess.aspx.designer.cs <span style='color:#111;'> 477B </span>","children":null,"spread":false},{"title":"Register.aspx.designer.cs <span style='color:#111;'> 1.17KB </span>","children":null,"spread":false},{"title":"Login.aspx.cs <span style='color:#111;'> 473B </span>","children":null,"spread":false},{"title":"Login.aspx <span style='color:#111;'> 3.00KB </span>","children":null,"spread":false},{"title":"ChangePassword.aspx <span style='color:#111;'> 4.35KB </span>","children":null,"spread":false},{"title":"Login.aspx.designer.cs <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false}],"spread":false},{"title":"Site.Master.designer.cs <span style='color:#111;'> 2.51KB </span>","children":null,"spread":false},{"title":"WebForm2.aspx <span style='color:#111;'> 646B </span>","children":null,"spread":false},{"title":"Web.config <span style='color:#111;'> 1.85KB </span>","children":null,"spread":false},{"title":"Styles","children":[{"title":"taobao.png <span style='color:#111;'> 1.30MB </span>","children":null,"spread":false},{"title":"Site.css <span style='color:#111;'> 4.16KB </span>","children":null,"spread":false},{"title":"adv.jpg <span style='color:#111;'> 5.59KB </span>","children":null,"spread":false}],"spread":true},{"title":"Student.cs <span style='color:#111;'> 815B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"WebApplication1.csproj.FileListAbsolute.txt <span style='color:#111;'> 545B </span>","children":null,"spread":false},{"title":"WebApplication1.dll <span style='color:#111;'> 16.50KB </span>","children":null,"spread":false},{"title":"WebApplication1.pdb <span style='color:#111;'> 57.50KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.98KB </span>","children":null,"spread":false},{"title":"ResolveAssemblyReference.cache <span style='color:#111;'> 16.67KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"Web.Debug.config <span style='color:#111;'> 1.19KB </span>","children":null,"spread":false},{"title":"About.aspx <span style='color:#111;'> 463B </span>","children":null,"spread":false},{"title":"WebForm1.aspx.cs <span style='color:#111;'> 337B </span>","children":null,"spread":false},{"title":"WebForm1.aspx.designer.cs <span style='color:#111;'> 472B </span>","children":null,"spread":false},{"title":"Default.aspx.designer.cs <span style='color:#111;'> 456B </span>","children":null,"spread":false},{"title":"App_Data","children":null,"spread":false},{"title":"WebForm2.aspx.designer.cs <span style='color:#111;'> 811B </span>","children":null,"spread":false},{"title":"About.aspx.cs <span style='color:#111;'> 336B </span>","children":null,"spread":false},{"title":"Web.Release.config <span style='color:#111;'> 1.25KB </span>","children":null,"spread":false},{"title":"SQLHelper.cs <span style='color:#111;'> 12.06KB </span>","children":null,"spread":false},{"title":"ExportExcel.aspx.designer.cs <span style='color:#111;'> 1.81KB </span>","children":null,"spread":false},{"title":"ExportExcel.aspx.cs <span style='color:#111;'> 8.48KB </span>","children":null,"spread":false},{"title":"Global.asax.cs <span style='color:#111;'> 1.18KB </span>","children":null,"spread":false},{"title":"Site.Master <span style='color:#111;'> 2.22KB </span>","children":null,"spread":false},{"title":"WebApplication1.csproj <span style='color:#111;'> 8.19KB </span>","children":null,"spread":false},{"title":"About.aspx.designer.cs <span style='color:#111;'> 453B </span>","children":null,"spread":false},{"title":"Global.asax <span style='color:#111;'> 99B </span>","children":null,"spread":false},{"title":"Scripts","children":[{"title":"jquery-1.4.1.js <span style='color:#111;'> 164.84KB </span>","children":null,"spread":false},{"title":"jquery-1.4.1-vsdoc.js <span style='color:#111;'> 234.21KB </span>","children":null,"spread":false},{"title":"jquery-1.4.1.min.js <span style='color:#111;'> 70.24KB </span>","children":null,"spread":false}],"spread":false},{"title":"WebApplication1.csproj.user <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"WebForm2.aspx.cs <span style='color:#111;'> 3.64KB </span>","children":null,"spread":false},{"title":"ExportExcel.aspx <span style='color:#111;'> 1.60KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.35KB </span>","children":null,"spread":false}],"spread":false},{"title":"Default.aspx.cs <span style='color:#111;'> 339B </span>","children":null,"spread":false}],"spread":false},{"title":"BinaryStu.sql <span style='color:#111;'> 205B </span>","children":null,"spread":false},{"title":"Stu.sql <span style='color:#111;'> 501B </span>","children":null,"spread":false},{"title":"WebApplication1.sln <span style='color:#111;'> 2.54KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • hanqx :
    很有帮助,谢谢楼主了!
    2019-01-25
  • mysdsn :
    可以使用,谢谢分享!
    2018-08-27
  • chenlinqi :
    NPOI做导出很好,不用安装Excel
    2017-12-13
  • yjmtvc :
    帮忙解决了问题
    2016-09-13
  • jsdyjcl :
    很不多哦。完全拷贝用上了
    2016-05-20

免责申明

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