Apache POI 一键上传(导入excel文件到数据库)
@Action("areaAction_uploadFile")public String areaAction_uploadFile() throws Exception {
List<Area> list = new ArrayList<>();
//使用POI技术解析excel文件
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(xlsFile));
HSSFSheet sheet = workbook.getSheet("Sheet1");
for (Row row : sheet) {
if(row.getRowNum()==0){
continue;
}
String> String province = row.getCell(1).getStringCellValue();
String city = row.getCell(2).getStringCellValue();
String district = row.getCell(3).getStringCellValue();
String postcode = row.getCell(4).getStringCellValue();
Area area = new Area(id, province, city, district, postcode, null, null);
province = province.substring(0, province.length()-1);
city = city.substring(0, city.length()-1);
district = district.substring(0, district.length()-1);
String info = province+city+district;
System.out.println(info);
// 简码: HBSJZQX
String[] headByString = PinYin4jUtils.getHeadByString(info);
String shortcode = StringUtils.join(headByString, "");
area.setShortcode(shortcode);
// 城市编码:shijiazhuang
String citycode = PinYin4jUtils.hanziToPinyin(city, "");
area.setCitycode(citycode);
list.add(area);
}
areaService.save(list);
return NONE;
}
页:
[1]