NPOI导出Excel(复杂表头)

上传者: mh942408056 | 上传时间: 2021-07-30 15:07:16 | 文件大小: 966KB | 文件类型: RAR
导出Excel包含的功能: 1.多表头导出最多支持到三行,表头格式说明 相邻父列头之间用'#'分隔,父列头与子列头用空格(' ')分隔,相邻子列头用逗号分隔(',') 两行:序号#分公司#组别#本日成功签约单数 预警,续约,流失,合计#累计成功签约单数 预警,续约,流失,合计#任务数#完成比例#排名 三行:等级#级别#上期结存 件数,重量,比例#本期调入 收购调入 件数,重量,比例#本期发出 车间投料 件数,重量,比例#本期发出 产品外销百分比 件数,重量,比例#平均值 三行时请注意:列头要重复 2.添加表头标题功能 3.添加序号功能 4.根据数据设置列宽 缺陷: 数据内容不能合并列合并行 改进思路: 添加一属性:设置要合并的列,为了实现多列合并可以这样设置{"列1,列2","列4"}

文件下载

资源详情

[{"title":"( 24 个子文件 966KB ) NPOI导出Excel(复杂表头)","children":[{"title":"NPOIDemo","children":[{"title":"bin","children":[{"title":"NPOIDemo.dll <span style='color:#111;'> 18.50KB </span>","children":null,"spread":false},{"title":"NPOI.dll <span style='color:#111;'> 1.55MB </span>","children":null,"spread":false},{"title":"NPOI.OpenXmlFormats.dll <span style='color:#111;'> 1.26MB </span>","children":null,"spread":false},{"title":"NPOIDemo.pdb <span style='color:#111;'> 55.50KB </span>","children":null,"spread":false},{"title":"NPOI.OpenXml4Net.dll <span style='color:#111;'> 78.00KB </span>","children":null,"spread":false},{"title":"NPOI.OOXML.dll <span style='color:#111;'> 378.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"DemoTest.aspx.designer.cs <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"Web.config <span style='color:#111;'> 313B </span>","children":null,"spread":false},{"title":"NPOIHelper.cs <span style='color:#111;'> 31.38KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"NPOIDemo.dll <span style='color:#111;'> 18.50KB </span>","children":null,"spread":false},{"title":"NPOIDemo.csproj.FileListAbsolute.txt <span style='color:#111;'> 376B </span>","children":null,"spread":false},{"title":"NPOIDemo.csprojResolveAssemblyReference.cache <span style='color:#111;'> 22.56KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.05KB </span>","children":null,"spread":false},{"title":"NPOIDemo.pdb <span style='color:#111;'> 55.50KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Web.Debug.config <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false},{"title":"NPOIDemo.csproj <span style='color:#111;'> 5.21KB </span>","children":null,"spread":false},{"title":"DemoTest.aspx.cs <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"说明.txt <span style='color:#111;'> 896B </span>","children":null,"spread":false},{"title":"Web.Release.config <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false},{"title":"DemoTest.aspx <span style='color:#111;'> 530B </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.31KB </span>","children":null,"spread":false}],"spread":true},{"title":"NPOIDemo.csproj.user <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false}],"spread":false},{"title":"NPOIDemo.suo <span style='color:#111;'> 35.00KB </span>","children":null,"spread":false},{"title":"NPOIDemo.sln <span style='color:#111;'> 914B </span>","children":null,"spread":false}],"spread":true}]

评论信息

  • u012767692 :
    博主QQ多少?
    2019-06-27
  • wxk723 :
    很好,收下了,感谢楼主
    2019-04-29
  • wbstudy :
    不错,可以借鉴
    2019-03-05
  • tingbing :
    很高,非常感谢,就是48个积分有点多
    2019-01-23
  • wao000000 :
    解决了问题,不错的demo
    2018-07-26

免责申明

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