java实现excel导入导出（jxl），Java面试题及解析

*/

public interface ExcelService {

void export(HttpServletResponse response, HttpServletRequest request);

List importExcel(String type, InputStream inputStream);

}

接口实现类

package com.mycompany.myapp.service.test.impl;

import com.mycompany.myapp.service.test.ExcelService;

import com.mycompany.myapp.util.DownloadFileUtil;

import com.mycompany.myapp.util.JxlUtil;

import com.mycompany.myapp.web.rest.vm.LoginVM;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

/**

• @description:

• @author: alan

• @time: 2021/7/25 21:38

*/

public class ExcelJxlServiceImpl implements ExcelService {

/**

• 导出excel

*/

@Override

public void export(HttpServletResponse response, HttpServletRequest request) {

// 文件新名

String newFileName = “UserInfo.xls”;

String pathName = “D:/usr/” + newFileName;

String title[] = {“账号”, “密码”, “登记”};

LoginVM loginOne = new LoginVM();

loginOne.setUsername(“小米”);

loginOne.setPassword(“123”);

loginOne.setRememberMe(true);

LoginVM loginTwo = new LoginVM();

loginTwo.setUsername(“小明”);

loginTwo.setPassword(“123”);

loginTwo.setRememberMe(false);

List list = new ArrayList<>(

《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》

【docs.qq.com/doc/DSmxTbFJ1cmN1R2dB】 完整内容开源分享

);

list.add(loginOne);

list.add(loginTwo);

//文件保存在指定位置

JxlUtil.exportExcel(pathName, title, list);

//获取文件流返回给客户端

DownloadFileUtil.downloadFile(response, request, pathName);

}

/**

• 导入

• @param type

• @param inputStream