有一个.CVS文件,里面包含数据
学号,姓名,语文,数学,外语,物理,化学
001,ZhangSan,86,70,84,93,78
002,LiSi,92,85,67,83,91
怎样从中读出数据,是不是首先应该先读取文件,然后再读取数据?
有哪位高手能帮忙解决问题吗,十分感激啊!!!
学号,姓名,语文,数学,外语,物理,化学
001,ZhangSan,86,70,84,93,78
002,LiSi,92,85,67,83,91
怎样从中读出数据,是不是首先应该先读取文件,然后再读取数据?
有哪位高手能帮忙解决问题吗,十分感激啊!!!
try{
BufferedReader o = new BufferedReader(new FileReader(path));
String line = "";
while((line=o.readLine()) != null){
if(line.trim().length() != 0){
String arr[] = line.trim().split(",");
for(int i=0;i<arr.length;i++)
System.out.print(arr[i]+"\t");
System.out.println();
}
}
}catch(Exception e){
}
}
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.Sheet;
import jxl.Cell;public class ExcelParser { public static void getExcelContent(String fileName) throws Exception {
Workbook rwb = null;
WorkbookSettings wse = new WorkbookSettings();
wse.setEncoding("ISO-8859-1");
rwb = Workbook.getWorkbook(new File(fileName), wse);
Sheet[] sheets = rwb.getSheets();
Sheet excelSheet = sheets[0];
Cell cjm = null;
for (int j = 1; j < excelSheet.getRows(); j++) {
for (int m = 0; m < excelSheet.getColumns(); m++) {
cjm = excelSheet.getCell(m, j);
System.out.println(cjm.getContents());
}
}
rwb.close();
}
public static void main(String args[]) throws Exception {
ExcelParser.getExcelContent("C:/study.csv");
}
}