POI导入导出
项目使用springboot mybatis mysql开发
转换excel表格注意当前表格的格式文件（xls用HSSF，xlsx用XSSF）
修改/src/test/java/impor/ImportFormExcel.java文件，
上传的文件放在/src/test/resources/下
傻瓜式操作
HSSFWorkbook hssfWorkbook = null;
HSSFSheet hssfSheet = null;
try (InputStream inputStream = getClass().getClassLoader().getResourceAsStream("cart.xls")){
//xssfWorkbook = new XSSFWorkbook(inputStream);
//获取当前的工作表格
hssfWorkbook = new HSSFWorkbook(inputStream);
//xssfSheet = xssfWorkbook.getSheetAt(0);
//获取工作对象
hssfSheet = hssfWorkbook.getSheetAt(0);
//int row = xssfSheet.getLastRowNum();
int row = hssfSheet.getLastRowNum();
for (int i = 1; i < row; i ) {
//XSSFRow xssfRow = xssfSheet.getRow(i);
HSSFRow hssfRow = hssfSheet.getRow(i);
TestCart cart = new TestCart();
cart.setOrderid(getValueInCell(hssfRow.getCell(0)));
cart.setIccid(getValueInCell(hssfRow.getCell(1)));
cart.setUsercode(getValueInCell(hssfRow.getCell(2)));
if(getValueInCell(hssfRow.getCell(3)).length()>0) {
cart.setTimetype(Integer.parseInt(getValueInCell(hssfRow.getCell(3))));
}
if(getValueInCell(hssfRow.getCell(4)).length()>0) {
cart.setTypes(Integer.parseInt(getValueInCell(hssfRow.getCell(4))));
}
System.out.println(cart.toString());
cartList.add(cart);
}
资源文件列表
spring-boot-excel-mysql/.classpath , 1433
spring-boot-excel-mysql/.project , 1142
spring-boot-excel-mysql/.settings/org.eclipse.core.resources.prefs , 191
spring-boot-excel-mysql/.settings/org.eclipse.jdt.core.prefs , 243
spring-boot-excel-mysql/.settings/org.eclipse.m2e.core.prefs , 90
spring-boot-excel-mysql/.settings/org.eclipse.wst.common.project.facet.core.xml , 145
spring-boot-excel-mysql/pom.xml , 2207
spring-boot-excel-mysql/readme.txt , 257
spring-boot-excel-mysql/src/main/java/com/wei/ssm/Application.java , 743
spring-boot-excel-mysql/src/main/java/com/wei/ssm/controller/CartController.java , 750
spring-boot-excel-mysql/src/main/java/com/wei/ssm/mapper/TestCartMapper.java , 825
spring-boot-excel-mysql/src/main/java/com/wei/ssm/pojo/TestCart.java , 1786
spring-boot-excel-mysql/src/main/java/com/wei/ssm/pojo/TestCartQuery.java , 17520
spring-boot-excel-mysql/src/main/java/com/wei/ssm/service/CartServiceI.java , 244
spring-boot-excel-mysql/src/main/java/com/wei/ssm/service/impl/CartServiceImpl.java , 896
spring-boot-excel-mysql/src/main/java/com/wei/ssm/util/PageUtil.java , 1875
spring-boot-excel-mysql/src/main/resources/application.properties , 1060
spring-boot-excel-mysql/src/main/resources/mybatis/mappers/TestCartMapper.xml , 7015
spring-boot-excel-mysql/src/main/resources/mybatis/mybatis-config.xml , 703
spring-boot-excel-mysql/src/main/webapp/resources/css/img/a.png , 8018
spring-boot-excel-mysql/src/main/webapp/resources/css/img/body.jpg , 14058
spring-boot-excel-mysql/src/main/webapp/resources/css/img/body1.jpg , 364436
spring-boot-excel-mysql/src/main/webapp/resources/css/img/body2.jpg , 923736
spring-boot-excel-mysql/src/main/webapp/resources/css/img/ing6.jpg , 276562
spring-boot-excel-mysql/src/main/webapp/resources/css/img/ing7.jpg , 335428
spring-boot-excel-mysql/src/main/webapp/resources/css/img/jdg222.jpg , 112695
spring-boot-excel-mysql/src/main/webapp/resources/css/img/sea.png , 9755
spring-boot-excel-mysql/src/main/webapp/resources/css/img/shuijiadog.gif , 3439313
spring-boot-excel-mysql/src/main/webapp/resources/css/img/zebratable.png , 5326
spring-boot-excel-mysql/src/main/webapp/resources/css/img/表.png , 10038
spring-boot-excel-mysql/src/main/webapp/resources/css/index_like.css , 2877
spring-boot-excel-mysql/src/main/webapp/resources/css/index_work.css , 5926
spring-boot-excel-mysql/src/main/webapp/resources/css/style.css , 533
spring-boot-excel-mysql/src/main/webapp/resources/image/2d2de07d464b658aa7700b37301e890d.gif , 371795
spring-boot-excel-mysql/src/main/webapp/resources/image/IMG_2649.JPG , 494820
spring-boot-excel-mysql/src/main/webapp/resources/image/ing1.jpg , 257733
spring-boot-excel-mysql/src/main/webapp/resources/image/ing2.jpg , 170317
spring-boot-excel-mysql/src/main/webapp/resources/image/ing3.jpg , 177337
spring-boot-excel-mysql/src/main/webapp/resources/image/ing4.jpg , 202726
spring-boot-excel-mysql/src/main/webapp/resources/image/ing5.jpg , 444702
spring-boot-excel-mysql/src/main/webapp/resources/image/ing6.jpg , 276562
spring-boot-excel-mysql/src/main/webapp/resources/image/ing7.jpg , 335428
spring-boot-excel-mysql/src/main/webapp/resources/image/ing8.png , 1100298
spring-boot-excel-mysql/src/main/webapp/resources/image/lansebeijing.jpg , 164173
spring-boot-excel-mysql/src/main/webapp/resources/image/qianzhihe.jpg , 297719
spring-boot-excel-mysql/src/main/webapp/resources/image/xiaoniao.jpg , 278069
spring-boot-excel-mysql/src/main/webapp/resources/image/未标题-1.png , 64605
spring-boot-excel-mysql/src/main/webapp/resources/inc/inc.jsp , 835
spring-boot-excel-mysql/src/main/webapp/resources/inc/pager.jsp , 956
spring-boot-excel-mysql/src/main/webapp/resources/js/angular.1.6.3.js , 167984
spring-boot-excel-mysql/src/main/webapp/resources/js/bootstrap-datetimepicker.js , 70107
spring-boot-excel-mysql/src/main/webapp/resources/js/bootstrap.js , 69707
spring-boot-excel-mysql/src/main/webapp/resources/js/jquery-1.8.2.min.js , 266882
spring-boot-excel-mysql/src/main/webapp/resources/js/jquery.js , 294745
spring-boot-excel-mysql/src/main/webapp/resources/js/jquery.validate.js , 35365
spring-boot-excel-mysql/src/main/webapp/resources/js/user.js , 3675
spring-boot-excel-mysql/src/main/webapp/WEB-INF/view/detail.jsp , 372
spring-boot-excel-mysql/src/main/webapp/WEB-INF/view/edit.jsp , 504
spring-boot-excel-mysql/src/main/webapp/WEB-INF/view/home.jsp , 1349
spring-boot-excel-mysql/src/test/java/impor/ImportFormExcel.java , 2880
spring-boot-excel-mysql/src/test/java/TestApplication.java , 1011
spring-boot-excel-mysql/src/test/resources/cart.xls , 26624
spring-boot-excel-mysql/target/classes/application.properties , 1060
spring-boot-excel-mysql/target/classes/com/wei/ssm/Application.class , 768
spring-boot-excel-mysql/target/classes/com/wei/ssm/controller/CartController.class , 1374
spring-boot-excel-mysql/target/classes/com/wei/ssm/mapper/TestCartMapper.class , 938
spring-boot-excel-mysql/target/classes/com/wei/ssm/pojo/TestCart.class , 2431
spring-boot-excel-mysql/target/classes/com/wei/ssm/pojo/TestCartQuery$Criteria.class , 6695
spring-boot-excel-mysql/target/classes/com/wei/ssm/pojo/TestCartQuery$Criterion.class , 2252
spring-boot-excel-mysql/target/classes/com/wei/ssm/pojo/TestCartQuery$GeneratedCriteria.class , 11554
spring-boot-excel-mysql/target/classes/com/wei/ssm/pojo/TestCartQuery.class , 3168
spring-boot-excel-mysql/target/classes/com/wei/ssm/service/CartServiceI.class , 315
spring-boot-excel-mysql/target/classes/com/wei/ssm/service/impl/CartServiceImpl.class , 1205
spring-boot-excel-mysql/target/classes/com/wei/ssm/util/PageUtil.class , 2355
spring-boot-excel-mysql/target/classes/META-INF/MANIFEST.MF , 397
spring-boot-excel-mysql/target/classes/META-INF/maven/com.wei.excel.mysql/spring-boot-excel-mysql/pom.properties , 278
spring-boot-excel-mysql/target/classes/META-INF/maven/com.wei.excel.mysql/spring-boot-excel-mysql/pom.xml , 2207
spring-boot-excel-mysql/target/classes/mybatis/mappers/TestCartMapper.xml , 7015
spring-boot-excel-mysql/target/classes/mybatis/mybatis-config.xml , 703
spring-boot-excel-mysql/target/test-classes/cart.xls , 26624
spring-boot-excel-mysql/target/test-classes/impor/ImportFormExcel.class , 4216
spring-boot-excel-mysql/target/test-classes/TestApplication.class , 1852