用J_Excel解析EXCEL表格的方法

git的地址:

https://github.com/hyberbin/J-Excel

代码:

	public static void main(String[] args) throws FileNotFoundException, IOException, JSONException {

		Workbook workbook = new HSSFWorkbook(
				new FileInputStream("F:\\coding\\git\\J-Excel\\src\\main\\resources\\xx - 副本.xls"));
		Sheet sheet = workbook.getSheet("aaa");
		ImportTableService tableService = new ImportTableService(sheet);
		tableService.setStartRow(1);
		tableService.doImport();
		List<ZxBusiTemplateVo> read = tableService.read(new String[] { "id", "customerId", "sheetNo", "productCode",
				"city", "marketingCenter", "area", "installedAddr", "cpeDeviceCode", "cpeType", "managerName",
				"managerPhone", "upBandwidth", "downBandwidth", "ipNum", "IP" }, ZxBusiTemplateVo.class);

		Sheet sheet2 = workbook.getSheet("bbb");
		ImportTableService tableService2 = new ImportTableService(sheet2);
		tableService2.setStartRow(1);
		tableService2.doImport();
		List<UserTemplateVO> read2 = tableService2.read(new String[] { "customerName", "customerId", "userId",
				"linkName", "linkPhone", "userIdNo", "account", "userName", "phone", "password" },
				UserTemplateVO.class);

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值