try {
File excelFile2 = new File("C:\Users\Administrator\Desktop\luyan/LTE逻辑站点查询_2015070815.xlsx"); // 创建文件对象
FileInputStream in = new FileInputStream(excelFile2); // 文件流
ExcelUtil.checkExcelVaild(excelFile2);
Workbook workbook=ExcelUtil.getWorkbok(in, excelFile2);//读取excel文件获取Workbook
workbook.getNumberOfSheets();
//System.out.println("Sheet的数量 ="+sheetCount);
Sheet sheet = workbook.getSheetAt(0);// 遍历第一个Sheet
System.out.println("数据量2"+sheet.getLastRowNum());
Row row=sheet.getRow(0);
System.out.println(row.getCell(0)+","+row.getCell(1)+","+row.getCell(2)+","
+row.getCell(3)+","+row.getCell(14)+","+row.getCell(15)+","+row.getCell(21)+","+row.getCell(25));
for(int i=1;i<1000;++i){
Row trow2=sheet.getRow(i);
Cell name=trow2.getCell(0);
Cell city=trow2.getCell(1);
Cell netWork_type =trow2.getCell(2);
Cell Site_type =trow2.getCell(3);
Cell longitude=trow2.getCell(14);
Cell latitude=trow2.getCell(15);
Cell manufacturers =trow2.getCell(21);
Cell Station_name=trow2.getCell(25);
list.add(Cell);
System.out.println(trow2.getCell(0)+","+trow2.getCell(1)+","+trow2.getCell(2)+","
+trow2.getCell(3)+","+trow2.getCell(14)+","+trow2.getCell(15)+","+trow2.getCell(21)+","+trow2.getCell(25));
}
System.out.println(list+"222222222222");
} catch (Exception e) {
System.out.println("出错"+e.toString());
}