java操作csv文件相关代码
发布时间:2020-12-14 23:38:19 所属栏目:Java 来源:网络整理
导读:今天PHP站长网 52php.cn把收集自互联网的代码分享给大家,仅供参考。 import java.io.BufferedReader;import java.io.FileReader;import java.io.IOException;import java.util.ArrayList;import java.util.Iterator;impo
以下代码由PHP站长网 52php.cn收集自互联网 现在PHP站长网小编把它分享给大家,仅供参考 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(); } } 以上内容由PHP站长网【52php.cn】收集整理供大家参考研究 如果以上内容对您有帮助,欢迎收藏、点赞、推荐、分享。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |