首页 开发技术 Java     /    excel资金转账流向分析

excel资金转账流向分析

上传者： fsgood520 | 上传时间：2024/3/29 17:25:39 | 文件大小：4.13MB | 文件类型：rar
excel资金转账流向分析
//循环工作表Sheetfor(intnumSheet=0;numSheet＜hssfWorkbook.getNumberOfSheets();numSheet++){//o--对应第一张工作表如默认情况下sheet1hssfSheet=hssfWorkbook.getSheetAt(numSheet);//System.out.println("表明"+hssfSheet.getSheetName());if(hssfSheet==null){continue;}//首先获得第一行的数据HSSFRowrowFirst=hssfSheet.getRow(0);//循环行Rowfor(introwNum=1;rowNum＜=hssfSheet.getLastRowNum();rowNum++){////获取行对象HSSFRowhssfRow=hssfSheet.getRow(rowNum);if(hssfRow!=null){//构建comp对象CompShowscomp=newCompShows();//初始化所有comp默认为1comp.setTypeOfTransaction(1);//根据列单元格的名字规划数据intt=hssfRow.getLastCellNum();//System.out.println(t+"fffffffffffffsssssssssssss");for(inti=0;i＜t;i++){//遍历根据i获得数据和列名HSSFCellhcFirst=rowFirst.getCell(i);//System.out.println(getValueForString(hcFirst)+"========");//if("客户帐号".equals(hssfrow))//获得每一列的列名HSSFCellhc=hssfRow.getCell(i);if("客户名称".equals(getValueForString(hcFirst).toString())||"户名".equals(getValueForString(hcFirst))||"交易户名".equals(getValueForString(hcFirst))){//System.out.println("客户账号"+getValue(hc));//表示该列数据存储的是账户名comp.setName((String)getValueForString(hc));}elseif("账号".equals(getValueForString(hcFirst))||"客户帐号".equals(getValueForString(hcFirst))||"交易账号".equals(getValueForString(hcFirst))){//表示该列数据存储的是账号comp.setAccount((String)getValueForString(hc));//System.out.println("账号"+getValue(hc));}elseif("交易日期".equals(getValueForString(hcFirst))||"交易时间".equals(getValueForString(hcFirst))){ 本软件ID:10649999

文件下载

资源详情

[{"title":"（43个子文件4.13MB）excel资金转账流向分析","children":[{"title":"showData","children":[{"title":"WebContent","children":[{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'>39B</span>","children":null,"spread":false}],"spread":true},{"title":"WEB-INF","children":[{"title":"web.xml <span style='color:#111;'>651B</span>","children":null,"spread":false},{"title":"lib","children":[{"title":"poi-3.6-20091214.jar <span style='color:#111;'>1.47MB</span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.10-bin.jar <span style='color:#111;'>707.25KB</span>","children":null,"spread":false},{"title":"xmlbeans-2.3.0.jar <span style='color:#111;'>2.54MB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'>6B</span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.project.facet.core.xml <span style='color:#111;'>345B</span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'>476B</span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.container <span style='color:#111;'>49B</span>","children":null,"spread":false},{"title":".jsdtscope <span style='color:#111;'>567B</span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'>364B</span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"config","children":[{"title":"info.properties <span style='color:#111;'>137B</span>","children":null,"spread":false}],"spread":true},{"title":"com","children":[{"title":"SmallGarlic","children":[{"title":"test","children":[{"title":"FormatData.java <span style='color:#111;'>1.31KB</span>","children":null,"spread":false},{"title":"Test.java <span style='color:#111;'>2.56KB</span>","children":null,"spread":false}],"spread":true},{"title":"service","children":[{"title":"CreatTree.java <span style='color:#111;'>6.85KB</span>","children":null,"spread":false}],"spread":true},{"title":"entity","children":[{"title":"Bill.java <span style='color:#111;'>1.12KB</span>","children":null,"spread":false},{"title":"Student.java <span style='color:#111;'>899B</span>","children":null,"spread":false},{"title":"Node.java <span style='color:#111;'>1.16KB</span>","children":null,"spread":false},{"title":"Tree.java <span style='color:#111;'>957B</span>","children":null,"spread":false},{"title":"Company.java <span style='color:#111;'>1.30KB</span>","children":null,"spread":false},{"title":"CompShows.java <span style='color:#111;'>3.35KB</span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"ConfigUtil.java <span style='color:#111;'>541B</span>","children":null,"spread":false},{"title":"Factory.java <span style='color:#111;'>374B</span>","children":null,"spread":false},{"title":"ReadExcelUtil.java <span style='color:#111;'>7.30KB</span>","children":null,"spread":false},{"title":"DAOUtil.java <span style='color:#111;'>5.86KB</span>","children":null,"spread":false},{"title":"DBUtil.java <span style='color:#111;'>941B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".project <span style='color:#111;'>908B</span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'>841B</span>","children":null,"spread":false},{"title":"build","children":[{"title":"classes","children":[{"title":"config","children":[{"title":"info.properties <span style='color:#111;'>137B</span>","children":null,"spread":false}],"spread":true},{"title":"com","children":[{"title":"SmallGarlic","children":[{"title":"test","children":[{"title":"Test.class <span style='color:#111;'>2.94KB</span>","children":null,"spread":false},{"title":"FormatData.class <span style='color:#111;'>1.32KB</span>","children":null,"spread":false}],"spread":true},{"title":"service","children":[{"title":"CreatTree.class <span style='color:#111;'>6.69KB</span>","children":null,"spread":false}],"spread":true},{"title":"entity","children":[{"title":"Bill.class <span style='color:#111;'>1.68KB</span>","children":null,"spread":false},{"title":"Company.class <span style='color:#111;'>2.17KB</span>","children":null,"spread":false},{"title":"Node.class <span style='color:#111;'>2.14KB</span>","children":null,"spread":false},{"title":"CompShows.class <span style='color:#111;'>3.40KB</span>","children":null,"spread":false},{"title":"Student.class <span style='color:#111;'>1.40KB</span>","children":null,"spread":false},{"title":"Tree.class <span style='color:#111;'>1.73KB</span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBUtil.class <span style='color:#111;'>1.40KB</span>","children":null,"spread":false},{"title":"Factory.class <span style='color:#111;'>864B</span>","children":null,"spread":false},{"title":"ConfigUtil.class <span style='color:#111;'>1.07KB</span>","children":null,"spread":false},{"title":"DAOUtil.class <span style='color:#111;'>4.85KB</span>","children":null,"spread":false},{"title":"ReadExcelUtil.class <span style='color:#111;'>4.70KB</span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • ?Banana?:
    具体怎么使用，请指导一下，已下载，具体作用是怎么样的2020-04-10
  • 曹倩云:
    我已经下载了，如何安装使用呢，可以接受收费，求指导2019-05-24
  • liushanmenpangge:
    请问一下这个软件怎么用2019-03-22

其他资源

免责申明

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

个人信息

|

一言

    • 相关资源标签

    热门下载

    最新下载