Apache POI导入Excel，以及PinYin4j的使用_02

最新推荐文章于 2019-04-20 10:13:35 发布

niki_yeun

最新推荐文章于 2019-04-20 10:13:35 发布

阅读量126

点赞数

分类专栏： POI

本文链接：https://blog.csdn.net/niki_yeun/article/details/82797510

版权

POI 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

核心API
 HSSFWorkbook : 提供读写Microsoft Excel XLS格式档案的功能。
 XSSFWorkbook : 提供读写Microsoft Excel XLSX格式档案的功能。

坐标

<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>${poi.version}</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>${poi.version}</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml-schemas</artifactId>
			<version>${poi.version}</version>
		</dependency>

java代码

public String importXLS() {
		// 用来保存数据的集合
		ArrayList<Area> list = new ArrayList<>();

		try {
			HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(file));
			// 读取工作簿
			HSSFSheet sheet = workbook.getSheetAt(0);
			// 遍历行
			for (Row row : sheet) {
				// 第一行是标题,这一行的数据不要
				if (row.getRowNum() == 0) {
					continue;
				}
				// 读取表格的数据
				String province = row.getCell(1).getStringCellValue();
				String city = row.getCell(2).getStringCellValue();
				String district = row.getCell(3).getStringCellValue();
				String postcode = row.getCell(4).getStringCellValue();

				// 截掉省市区的最后一个字符
				province = province.substring(0, province.length() - 1);
				city = city.substring(0, city.length() - 1);
				district = district.substring(0, district.length() - 1);
				// 获取城市编码
				String citycode = PinYin4jUtils.hanziToPinyin(city, "").toUpperCase();
				String[] headByString = PinYin4jUtils.getHeadByString(province + city + district, true);
				// 获取简码
				String shortcode = PinYin4jUtils.stringArrayToString(headByString);
				// 构造一个Area
				Area area = new Area();
				area.setProvince(province);
				area.setCity(city);
				area.setDistrict(district);
				area.setPostcode(postcode);
				area.setCitycode(citycode);
				area.setShortcode(shortcode);
				// 添加到集合
				list.add(area);
			}
			// 一次性保存区域数据
			areaService.save(list);
			// 释放资源
			workbook.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

		return SUCCESS;
	}

PinYin4J的使用

坐标

	<dependency>
			<groupId>com.belerweb</groupId>
			<artifactId>pinyin4j</artifactId>
			<version>2.5.0</version>
		</dependency>

javaDemo

public static void main(String[] args) {
		String province = "广东省";
		String city = "深圳市";
		String district = "宝安区";

		// 简码 GDSZBA 城市编码 SHENZHEN

		province = province.substring(0, province.length() - 1);
		city = city.substring(0, city.length() - 1);
		district = district.substring(0, district.length() - 1);

//		String hanziToPinyin = PinYin4jUtils.hanziToPinyin(city, "").toUpperCase();
//		System.out.println(hanziToPinyin);
		
		String[] headByString = PinYin4jUtils.getHeadByString(province+city+district, true);
		
		String stringArrayToString = PinYin4jUtils.stringArrayToString(headByString);
		System.out.println(stringArrayToString);

	}