C#导出EXCEL源码(可手动灵活配置Excel模版)

上传者: jzdzhiyun | 上传时间: 2021-08-21 16:30:46 | 文件大小: 490KB | 文件类型: RAR
1、Excel模版在:WebExcelOut\Cfg\ExcelModel。Excel第一页页签是内容,里面的数字表示DataTable中的第几个列(0列为第一列);第二页签是导出Excel的表头。 2、WebExcelOut\Cfg\ExcelCfg.xml中配置使用模版中的哪列哪行等信息。 辅助参考资料:服务器配置http://blog.csdn.net/jzdzhiyun/archive/2010/11/08/5996417.aspx

文件下载

资源详情

[{"title":"( 89 个子文件 490KB ) C#导出EXCEL源码(可手动灵活配置Excel模版)","children":[{"title":"WebExcelOut","children":[{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 362B </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"WebExcelOut.sln.svn-base <span style='color:#111;'> 923B </span>","children":null,"spread":false}],"spread":true},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":true},{"title":"prop-base","children":null,"spread":false}],"spread":true},{"title":"WebExcelOut","children":[{"title":"UpFiles","children":[{"title":"2010","children":[{"title":"10","children":[{"title":"ghkgu6765786.txt <span style='color:#111;'> 385B </span>","children":null,"spread":false},{"title":"asdfasdfasd.txt <span style='color:#111;'> 385B </span>","children":null,"spread":false}],"spread":true},{"title":"11","children":[{"title":"打印@20101108173309937b278bA67baA444aA9af6A8d9d26f8eaab.mht <span style='color:#111;'> 45.82KB </span>","children":null,"spread":false},{"title":"1108@20101108173303c6726173A93d4A417aA9296Ae6b6b1797bee.csv <span style='color:#111;'> 682B </span>","children":null,"spread":false},{"title":"tempOracle@20101109092151d69a55e9A9d4bA4984A8982A11a6aaea50a2.sql <span style='color:#111;'> 1.57KB </span>","children":null,"spread":false},{"title":"1108@20101108173253fdd49e92Ada60A447aA9b4dA7f2005d042d4.csv <span style='color:#111;'> 682B </span>","children":null,"spread":false},{"title":"Asp.net访问Excel之windows设置@20101108173258c75137c0Aa82aA4e63A8a86Acf2f96821887.doc <span style='color:#111;'> 33.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"WebExcelOut.csproj.user <span style='color:#111;'> 1.29KB </span>","children":null,"spread":false},{"title":"FileUpLoad.aspx.designer.cs <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":"CLASS","children":[{"title":"ExcelHelper.cs <span style='color:#111;'> 21.03KB </span>","children":null,"spread":false},{"title":"FileUplHelper.cs <span style='color:#111;'> 9.10KB </span>","children":null,"spread":false},{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 665B </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"副本 ExcelHelper.cs.svn-base <span style='color:#111;'> 21.03KB </span>","children":null,"spread":false},{"title":"CToolMge.cs.svn-base <span style='color:#111;'> 19.40KB </span>","children":null,"spread":false},{"title":"FileUplHelper.cs.svn-base <span style='color:#111;'> 9.10KB </span>","children":null,"spread":false},{"title":"ExcelHelper.cs.svn-base <span style='color:#111;'> 21.03KB </span>","children":null,"spread":false}],"spread":true},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":true},{"title":"CToolMge.cs <span style='color:#111;'> 19.40KB </span>","children":null,"spread":false}],"spread":true},{"title":"bin","children":[{"title":"WebExcelOut.dll <span style='color:#111;'> 23.00KB </span>","children":null,"spread":false},{"title":"WebExcelOut.pdb <span style='color:#111;'> 61.50KB </span>","children":null,"spread":false},{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 396B </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"Microsoft.Office.Interop.Excel.dll.svn-base <span style='color:#111;'> 1.05MB </span>","children":null,"spread":false}],"spread":true},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":[{"title":"Microsoft.Office.Interop.Excel.dll.svn-base <span style='color:#111;'> 53B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"Microsoft.Office.Interop.Excel.dll <span style='color:#111;'> 1.05MB </span>","children":null,"spread":false}],"spread":true},{"title":"Web.config <span style='color:#111;'> 1.52KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"WebExcelOut.dll <span style='color:#111;'> 23.00KB </span>","children":null,"spread":false},{"title":"ResolveAssemblyReference.cache <span style='color:#111;'> 8.97KB </span>","children":null,"spread":false},{"title":"WebExcelOut.csproj.FileListAbsolute.txt <span style='color:#111;'> 378B </span>","children":null,"spread":false},{"title":"WebExcelOut.pdb <span style='color:#111;'> 61.50KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Properties","children":[{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 369B </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"AssemblyInfo.cs.svn-base <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false}],"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":true},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false}],"spread":true},{"title":"FileUpLoad.aspx <span style='color:#111;'> 752B </span>","children":null,"spread":false},{"title":"FileUpLoadList.aspx.cs <span style='color:#111;'> 3.41KB </span>","children":null,"spread":false},{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 2.40KB </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"Default.aspx.designer.cs.svn-base <span style='color:#111;'> 835B </span>","children":null,"spread":false},{"title":"Handler1.ashx.svn-base <span style='color:#111;'> 95B </span>","children":null,"spread":false},{"title":"副本 FileUpLoad.aspx.cs.svn-base <span style='color:#111;'> 3.42KB </span>","children":null,"spread":false},{"title":"FileUpLoadList.aspx.cs.svn-base <span style='color:#111;'> 2.80KB </span>","children":null,"spread":false},{"title":"WebExcelOut.csproj.user.svn-base <span style='color:#111;'> 1.29KB </span>","children":null,"spread":false},{"title":"Default.aspx.svn-base <span style='color:#111;'> 446B </span>","children":null,"spread":false},{"title":"FileUpLoadList.aspx.svn-base <span style='color:#111;'> 3.83KB </span>","children":null,"spread":false},{"title":"Default.aspx.cs.svn-base <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"FileUpLoad.aspx.svn-base <span style='color:#111;'> 752B </span>","children":null,"spread":false},{"title":"副本 FileUpLoad.aspx.svn-base <span style='color:#111;'> 580B </span>","children":null,"spread":false},{"title":"Handler1.ashx.cs.svn-base <span style='color:#111;'> 963B </span>","children":null,"spread":false},{"title":"FileUpLoadList.aspx.designer.cs.svn-base <span style='color:#111;'> 2.89KB </span>","children":null,"spread":false},{"title":"FileUpLoad.aspx.cs.svn-base <span style='color:#111;'> 830B </span>","children":null,"spread":false},{"title":"FileUpLoad.aspx.designer.cs.svn-base <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":"Web.config.svn-base <span style='color:#111;'> 1.52KB </span>","children":null,"spread":false},{"title":"副本 FileUpLoad.aspx.designer.cs.svn-base <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":"WebExcelOut.csproj.svn-base <span style='color:#111;'> 5.05KB </span>","children":null,"spread":false}],"spread":false},{"title":"dir-prop-base <span style='color:#111;'> 76B </span>","children":null,"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":true},{"title":"Cfg","children":[{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 376B </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"ExcelCfg.xml.svn-base <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false}],"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"ExcelCfg.xml <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false},{"title":"ExcelModel","children":[{"title":"BaseModel.xls <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false},{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 541B </span>","children":null,"spread":false},{"title":"text-base","children":[{"title":"AnJianFactory.xls.svn-base <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false},{"title":"BaseModel.xls.svn-base <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":[{"title":"AnJianFactory.xls.svn-base <span style='color:#111;'> 53B </span>","children":null,"spread":false},{"title":"BaseModel.xls.svn-base <span style='color:#111;'> 53B </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"AnJianFactory.xls <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"App_Data","children":[{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 219B </span>","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"WebExcelOut.csproj <span style='color:#111;'> 5.05KB </span>","children":null,"spread":false},{"title":"Default.aspx <span style='color:#111;'> 446B </span>","children":null,"spread":false},{"title":"Default.aspx.cs <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"Handler1.ashx.cs <span style='color:#111;'> 963B </span>","children":null,"spread":false},{"title":"Default.aspx.designer.cs <span style='color:#111;'> 835B </span>","children":null,"spread":false},{"title":"FileUpLoad.aspx.cs <span style='color:#111;'> 830B </span>","children":null,"spread":false},{"title":"Handler1.ashx <span style='color:#111;'> 95B </span>","children":null,"spread":false},{"title":"PrintPage","children":[{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 235B </span>","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"ExcelOut","children":[{"title":".svn","children":[{"title":"props","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 229B </span>","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"format <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"tmp","children":[{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false},{"title":"prop-base","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false},{"title":"WebExcelOut.Publish.xml <span style='color:#111;'> 945B </span>","children":null,"spread":false},{"title":"FileUpLoadList.aspx <span style='color:#111;'> 4.02KB </span>","children":null,"spread":false},{"title":"FileUpLoadList.aspx.designer.cs <span style='color:#111;'> 2.89KB </span>","children":null,"spread":false}],"spread":false},{"title":"WebExcelOut.sln <span style='color:#111;'> 923B </span>","children":null,"spread":false},{"title":"WebExcelOut.suo <span style='color:#111;'> 23.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • wyws2008 :
    有很大的参考意义。不错。
    2017-05-09
  • guyuecaoyang :
    有帮助,谢谢分享
    2015-11-02
  • guoyixue518 :
    还可以。用处不是很大。
    2014-11-29
  • wjq986781910 :
    很好,正是需要的,谢谢了
    2014-11-10
  • lixin2732r :
    谢谢分享,还可以,但是我用着还是不太灵活
    2014-10-15

免责申明

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