一、maven配置
导入excel表格需要使用的依赖:
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.0.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.0.0</version>
</dependency>
二、测试程序
package utils;
import java.io.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class AddData {
public static String userPath = "C:/Users/DELL/Desktop/user";
public static String excelPath = "C:/Users/DELL/Desktop/user.xlsx";
public static BufferedReader userIn = null;
public static BufferedWriter userOut = null;
public static int userNum ;
public static int excelUserNum;
public static String userContent = null;
public static String excelContent = null;
public static String readUserInfo(Strin