FileInputStream fileInputStream = new FileInputStream(new File("C:/表-v1.0.xlsx"));
//读取工作簿
XSSFWorkbook workbook = new XSSFWorkbook(fileInputStream);
//读取配电信息工作表(getSheet(name)可根据name获取sheet)
XSSFSheet sheet = workbook.getSheet("配电关系");
//配电进线信息录入
for (int i=2;i<sheet.getLastRowNum();i++) {
XSSFRow row = sheet.getRow(i);
//创建一个集合存储每个row的数据
List<String> list = new ArrayList<String>();
//从0开始到4列
for(int c=0;c<4;c++){
String li = null;
try {
row.getCell(c).setCellType(Cell.CELL_TYPE_STRING);
li =row.getCell(c).getStringCellValue();
list.add(li);
} catch (NullPointerException e) {
if(li==null){
list.add("");
continue;
}
}
}
coil.setBno(list.get(0));
coil.setDleno(list.get(1));
coil.setDname(list.get(2));
coil.setDistributionRoom(list.get(3));
if(!list.get(1).equals("")){
importInfoService.addCoil(coil);
}
}