java操作csv文件相关代码
发布时间:2020-05-24 19:24:44 所属栏目:Java 来源:互联网
导读:java操作csv文件相关代码
下面是脚本之家 jb51.cc 通过网络收集整理的代码片段。 脚本之家小编现在分享给大家,也给大家做个参考。 import java.io.BufferedReader; import java.io.FileReader; import java.io.IOException; import java.util.ArrayList; import java.util.Iterator; import java.util.List; /** * * JAVA 操作 excel 文档中的 .csv文件格式 */ public class CsvOperateUtil { private String filename = null; private BufferedReader bufferedreader = null; private List list =new ArrayList(); public CsvOperateUtil() { } public static void main(String[] args) throws IOException { CsvOperateUtil test = new CsvOperateUtil(); test.testRun("C:/file2/B_F_DEP_SAE_CB_ACCT_TMP.csv"); } public CsvOperateUtil(String filename) throws IOException{ this.filename = filename; bufferedreader = new BufferedReader(new FileReader(filename)); String stemp; while((stemp = bufferedreader.readLine()) != null){ list.add(stemp); } } public List getList() throws IOException { return list; } public int getRowNum(){ return list.size(); } public int getColNum(){ if(!list.toString().equals("[]")) { if(list.get(0).toString().indexOf(",")>0) { return list.get(0).toString().split(",").length; }else if(list.get(0).toString().trim().length() != 0) { return 1; }else{ return 0; } }else{ return 0; } } public String getRow(int index) { if (this.list.size() != 0) return (String) list.get(index); else return null; } public String getCol(int index){ if (this.getColNum() == 0){ return null; } StringBuffer scol = new StringBuffer(); String temp = null; int colnum = this.getColNum(); if (colnum > 1){ for (Iterator it = list.iterator(); it.hasNext();) { temp = it.next().toString(); scol = scol.append(temp.split(",")[index] + ","); } }else{ for (Iterator it = list.iterator(); it.hasNext();) { temp = it.next().toString(); scol = scol.append(temp + ","); } } String str=new String(scol.toString()); str = str.substring(0,str.length() - 1); return str; } public String getString(int row,int col) { String temp = null; int colnum = this.getColNum(); if(colnum > 1){ temp = list.get(row).toString().split(",")[col]; }else if(colnum == 1) { temp = list.get(row).toString(); }else{ temp = null; } return temp; } public void CsvClose() throws IOException { this.bufferedreader.close(); } public void testRun(String filename) throws IOException { CsvOperateUtil cu = new CsvOperateUtil(filename); for(int i=0;i<cu.getRowNum();i++){ String ID = cu.getString(i,0);//得到第i行.第一列的数据. String CODE = cu.getString(i,1);;//得到第i行.第二列的数据. String NAME = cu.getString(i,2);; String TEL = cu.getString(i,3);; System.out.println("===ID:"+ID); System.out.println("===CODE:"+CODE); System.out.println("===NAME:"+NAME); System.out.println("===TEL:"+TEL); System.out.println(" "); } cu.CsvClose(); } } 以上是脚本之家(jb51.cc)为你收集整理的全部代码内容,希望文章能够帮你解决所遇到的程序开发问题。 如果觉得脚本之家网站内容还不错,欢迎将脚本之家网站推荐给程序员好友。 (编辑:安卓应用网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |