java实现excel导入导出（jxl），java反射机制的原理和用途

loginTwo.setUsername(“小明”);

loginTwo.setPassword(“123”);

loginTwo.setRememberMe(false);

List list = new ArrayList<>();

list.add(loginOne);

list.add(loginTwo);

//文件保存在指定位置

JxlUtil.exportExcel(pathName, title, list);

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

DownloadFileUtil.downloadFile(response, request, pathName);

}

/**

• 导入

• @param type

• @param inputStream

• @return

*/

@Override

public List importExcel(String type, InputStream inputStream) {

List list = new ArrayList();

if (type.equals(“xls”)) {

list = JxlUtil.xlsContent(inputStream);

} else {

list = JxlUtil.csvContent(inputStream);

}

return list;

}

}

jxl工具类

package com.mycompany.myapp.util;

import jxl.Sheet;

import jxl.Workbook;

import jxl.format.Alignment;

import jxl.format.Border;

import jxl.format.BorderLineStyle;

import jxl.format.VerticalAlignment;

import jxl.read.biff.BiffException;

import jxl.write.*;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import java.io.*;

import java.lang.reflect.Field;

import java.math.BigDecimal;

import java.text.DecimalFormat;

import java.util.ArrayList;

import java.util.List;

/**

• @description:

• @author: alan

• @time: 2021/7/23 18:26

*/

public class JxlUtil {

/**

• 导出Excel

• @param fileName 文件地址名称

• @param Title 导出excel的标题

• @param listContent 导出的list

• @return

*/

public final static boolean exportExcel(String fileName, String[] Title, List<?> listContent) {

final Logger logger = LoggerFactory.getLogger(JxlUtil.class);

WritableWorkbook workbook = null;

// 以下开始输出到EXCEL