前言:
刚开始导入Excel的时候,每次有新的Excel文件需要导入的时候就需要重新再新写一个对应的工具来导入excel。所以,鄙人痛定思痛,觉得有必要写一个可以万能导入的Excel工具。
上代码:
private final static String xls = "xls";
private final static String xlsx = "xlsx";
public static Map readExcelPOIT(Object obj) throws Exception
{
// FileInputStream fis = (FileInputStream) file.getInputStream();
Map jsonObject = new HashMap<>();
String msg = null;
List msgList = new ArrayList<>();
//创建输入流
FileInputStream fis = new FileInputStream(new File("g:\\data\\test.xlsx"));
//通过构造函数传参
Workbook workbook = getWorkBookT(new File("g:\\data\\test.xlsx"));
// Workbook workbook = getWorkBook(file);
int sheets = workbook.getNumberOfSheets();
if (sheets<1){
msg