Read CSV from file
File Format
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
...
Code
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();
|