今天從網上找了一個讀寫csv格式的開源程序，還挺好用的。

下面是一個讀取例子：

源文件格式：

?ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued
?1,Chai,1,1,10 boxes x 20 bags,18,39,0,10,FALSE
?2,Chang,1,1,24 - 12 oz bottles,19,17,40,25,FALSE

?下面讀取程序

?

?CsvReader?reader? = ? new ?CsvReader( " products.csv " );

?reader.readHeaders();

? while ?(reader.readRecord())
? {
??String?productID? = ?reader.get( " ProductID " );
??String?productName? = ?reader.get( " ProductName " );
??String?supplierID? = ?reader.get( " SupplierID " );
??String?categoryID? = ?reader.get( " CategoryID " );
??String?quantityPerUnit? = ?reader.get( " QuantityPerUnit " );
??String?unitPrice? = ?reader.get( " UnitPrice " );
??String?unitsInStock? = ?reader.get( " UnitsInStock " );
??String?unitsOnOrder? = ?reader.get( " UnitsOnOrder " );
??String?reorderLevel? = ?reader.get( " ReorderLevel " );
??String?discontinued? = ?reader.get( " Discontinued " );
??
?? // ?perform?program?logic?here

?}

?reader.close();

寫CSV例子：

?CsvWriter writer = new CsvWriter(new FileWriter(new File("c:\\1.csv")),',');
??writer.write("aa");
??writer.write("bb");
??writer.write("cc");
??writer.endRecord();
??writer.write("1");
??writer.write("2");
??writer.write("3");
??writer.close();