easyexcel导入导出excel-下代码

1、pom引入easyexcel包
```java
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>easyexcel</artifactId>
			<version>3.1.3</version>
		</dependency>
```
2、导出excel
```java
	@RequestMapping(value = "/exportXls", method = RequestMethod.GET)
	public void exportXls(HttpServletRequest request, HttpServletResponse response)throws IOException {
		response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
		response.setCharacterEncoding("utf-8");
		// 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
		String fileName = URLEncoder.encode("网点信息数据", "UTF-8").replaceAll("\\+", "%20");
		response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
		List<NetworkTabl> listDatas = networkTablService.list();
		EasyExcel.write(response.getOutputStream(), NetworkTabl.class).sheet("sheet").doWrite(listDatas);
	}
```
3、导入excel
```java
	/**
	 * 通过excel导入数据
	 *
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/importExcel", method = RequestMethod.POST)
	public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response)throws IOException {
		JSONObject jsonObject = new JSONObject();

MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
		for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
			MultipartFile file = entity.getValue();// 获取上传文件对象
			try {
				NetworkTablListener networkTablListener = new NetworkTablListener();
				EasyExcel.read(file.getInputStream(), NetworkTabl.class, networkTablListener).sheet(0).doRead();
				List<NetworkTabl> listDatas = networkTablListener.getDataList();
				List<NetworkTabl> dListDatas = networkTablService.list();
				Map<String,NetworkTabl> dnetworkTablMap = EntityMd5Util.getNetworkTablMap(dListDatas);

List<NetworkTabl> saveListDatas = new ArrayList<>();
				List<NetworkTabl> updateListDatas = new ArrayList<>();
				for(NetworkTabl networkTabl : listDatas){
					String key = EntityMd5Util.getNetworkTablKey(networkTabl);
					String md5 = EntityMd5Util.getNetworkTablMd5(networkTabl);
					if(dnetworkTablMap.keySet().contains(key)){
						NetworkTabl dNetworkTabl = dnetworkTablMap.get(key);
						String dmd5 = EntityMd5Util.getNetworkTablMd5(dNetworkTabl);
						if(!(md5.equals(dmd5))){
							networkTabl.setId(dNetworkTabl.getId());
							updateListDatas.add(networkTabl);
						}
					}else{
						saveListDatas.add(networkTabl);
					}
				}

if(CollectionUtils.isNotEmpty(saveListDatas)){
					networkTablService.saveBatch(saveListDatas);
				}
				if(CollectionUtils.isNotEmpty(updateListDatas)){
					networkTablService.updateBatchById(updateListDatas);
				}
				jsonObject.put("totalNum",listDatas.size());
			} catch (Exception e) {
				log.error(e.getMessage(), e);
				return new Result<>().error500("导入失败");
			} finally {
				try {
					file.getInputStream().close();
				} catch (IOException e) {
					log.error(e.getMessage(), e);
				}
			}
		}

return Result.OK(jsonObject);
	}

```
```java
package org.dkp.modules.system.excel;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.read.listener.ReadListener;
import com.alibaba.fastjson.JSON;
import lombok.extern.slf4j.Slf4j;
import org.dkp.modules.system.entity.NetworkTabl;

import java.util.ArrayList;
import java.util.List;

@Slf4j
public class NetworkTablListener implements ReadListener<NetworkTabl> {

private List<NetworkTabl> dataList = new ArrayList<>();

public List<NetworkTabl> getDataList() {
        return dataList;
    }

public NetworkTablListener(){

}

/**
     * 这个每一条数据解析都会来调用
     *
     * @param data    one row value. Is is same as {@link AnalysisContext#readRowHolder()}
     * @param context
     */
    @Override
    public void invoke(NetworkTabl data, AnalysisContext context) {
        log.info("解析到一条数据:{}", JSON.toJSONString(data));
        dataList.add(data);
    }

/**
     * 所有数据解析完成了 都会来调用
     *
     * @param context
     */
    @Override
    public void doAfterAllAnalysed(AnalysisContext context){
        // 这里也要保存数据，确保最后遗留的数据也存储到数据库
        log.info("所有数据解析完成！");
    }
}

```

网站模板

您现在的位置：网站首页 > 建站教程 >

easyexcel导入导出excel

相关阅读

网站模板

您现在的位置： 网站首页 > 建站教程 >

easyexcel导入导出excel

相关阅读

您现在的位置：网站首页 > 建站教程 >