操作工具 eclipse + maven
1. java操作excel所使用的jar包 poi-ooxml
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.14</version>
</dependency>
2.在本地建立一个excel文件
路径:C:/Users/liuyouchao/Desktop/test.xlsx
内容如下
3.书写代码实现
package com.daojia.certify.excelimport;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import com.alibaba.fastjson.JSON;
import com.daojia.certify.util.DateBuilder;
/**
* @Description : TODO导入excel
* @date : Mar 31, 2018 5:17:14 PM
*/
public class ExcelImport {
public static void main(S