import cn.XXXX.bos.utils.PinYin4jUtils;import org.apache.commons.lang3.StringUtils;
// HSSF:操作07版本之前 后缀名xxx.xls
// XSSF:操作07版本之后 后缀名xx.xlsx
@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 id = row.getCell(0).getStringCellValue();
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;
}