java csv 导入 导出 修改



注:需要javacsv.jar

package csv;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.List;

import com.csvreader.CsvReader;
import com.csvreader.CsvWriter;

public class csvTest {

 public static void main(String[] args) throws IOException {
       String filePath="d:/score.scv";
  //writeCsv(filePath);
  //readCsv(filePath);
  modifyCsv(filePath);
 }

 private static void modifyCsv(String filePath) throws IOException {
  List<String[]> list = new ArrayList<String[]>();
        CsvReader reader = new CsvReader(filePath,',',Charset.forName("GBK"));
        CsvWriter wr = new CsvWriter("d:/score1.scv",',',Charset.forName("GBK"));
        //reader.readHeaders();   // 跳过表头   如果需要表头的话，不要写这句。 
        while (reader.readRecord()) {    //逐行读入除表头的数据  
         list.add(reader.getValues());
   
  }
       
        for (int i = 0; i < list.size(); i++) {
         
   String[] cell =list.get(i);
   for (int j = 0; j < cell.length; j++) {
    
    cell[j]=cell[j]+j;
    System.out.println("cell---->"+cell[j]);
   }
   
   wr.writeRecord(cell);
  }
        wr.close();
 }

 private static void readCsv(String filePath) throws IOException {
  List<String[]> list = new ArrayList<String[]>();
        CsvReader reader = new CsvReader(filePath,',',Charset.forName("GBK"));
        reader.readHeaders();   // 跳过表头   如果需要表头的话，不要写这句。 
        while (reader.readRecord()) {    //逐行读入除表头的数据  
         list.add(reader.getValues());
   
  }
       
        for (int i = 0; i < list.size(); i++) {
         
   String[] cell =list.get(i);
   for (int j = 0; j < cell.length; j++) {
    System.out.println("cell---->"+cell[j]);
   }
   
  }
 }

 private static void writeCsv(String filePath) throws IOException {

  CsvWriter wr = new CsvWriter(filePath,',',Charset.forName("GBK"));
  String[] contents={"aaa","bbbbb","ddddd","eeeee"};
  wr.writeRecord(contents);
  wr.close();
  
 }

}