文件形式保存
有图片的导出就有图片的导入,导入的配置和导出是一样的,但是需要设置保存路径
1.设置保存路径saveUrl 默认为”upload/excelUpload”
可以手动修改 ImportParams 修改下就可以了
@Test
public void test() {
try {
ImportParams params = new ImportParams();
params.setNeedSave(true);
List<CompanyHasImgModel> result = ExcelImportUtil.importExcel(
new File(PoiPublicUtil.getWebRootPath("import/imgexcel.xls")),
CompanyHasImgModel.class, params);
for (int i = 0; i < result.size(); i++) {
System.out.println(ReflectionToStringBuilder.toString(result.get(i)));
}
Assert.assertTrue(result.size() == 4);
} catch (Exception e) {
e.printStackTrace();
}
}
}
导入日志
16:35:43.081 [main] DEBUG c.a.e.e.imports.ExcelImportServer - Excel import start ,class is class cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel
16:35:43.323 [main] DEBUG c.a.e.e.imports.ExcelImportServer - start to read excel by is ,startTime is 1503650143323
16:35:43.344 [main] DEBUG c.a.e.e.imports.ExcelImportServer - end to read excel by is ,endTime is 1503650143344
16:35:43.429 [main] DEBUG c.a.e.e.imports.ExcelImportServer - end to read excel list by pos ,endTime is 1503650143429
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@1b083826[companyName=百度,companyLogo=upload/CompanyHasImgModel/pic88273295062.PNG,companyAddr=北京市海淀区西北旺东路10号院百度科技园1号楼]
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@105fece7[companyName=阿里巴巴,companyLogo=upload/CompanyHasImgModel/pic22507938183.PNG,companyAddr=北京市海淀区西北旺东路10号院百度科技园1号楼]
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@3ec300f1[companyName=Lemur,companyLogo=upload/CompanyHasImgModel/pic86390457892.PNG,companyAddr=亚马逊热带雨林]
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@482cd91f[companyName=一众,companyLogo=upload/CompanyHasImgModel/pic69566571093.PNG,companyAddr=山东济宁俺家]

自定义图片保存
@since 5.0
如果我们要自己保存,或者我们要保存的三方文件服务,这个时候我们自己实现文件接口
实现比如上传的7牛或者其他文件服务,返回id,这边把id保存起来
@Test
public void test() {
try {
ImportParams params = new ImportParams();
params.setNeedSave(true);
params.setPoiFileHandler(new IPoiFileHandler() {
@Override
public String saveImgFile(String fileName, byte[] data, Object object) {
return fileName+ "这是测试地址";
}
});
List<CompanyHasImgModel> result = ExcelImportUtil.importExcel(
new File(FileUtilTest.getWebRootPath("import/imgexcel.xls")),
CompanyHasImgModel.class, params);
for (int i = 0; i < result.size(); i++) {
System.out.println(ReflectionToStringBuilder.toString(result.get(i)));
}
Assert.assertTrue(result.size() == 4);
} catch (Exception e) {
e.printStackTrace();
}
}
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@1f32542[companyName=百度,companyLogo=pic44415397859.PNG这是测试地址,companyAddr=北京市海淀区西北旺东路10号院百度科技园1号楼]
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@1d6b6c7[companyName=阿里巴巴,companyLogo=pic58864653220.PNG这是测试地址,companyAddr=北京市海淀区西北旺东路10号院百度科技园1号楼]
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@1fa9431[companyName=Lemur,companyLogo=pic74812672464.PNG这是测试地址,companyAddr=亚马逊热带雨林]
cn.afterturn.easypoi.test.entity.img.CompanyHasImgModel@1b250b4[companyName=一众,companyLogo=pic18378731423.PNG这是测试地址,companyAddr=山东济宁俺家]作者:悟耘信息 创建时间:2020-04-08 16:00
最后编辑:悟耘信息 更新时间:2024-08-18 12:21
最后编辑:悟耘信息 更新时间:2024-08-18 12:21