jar 包下载: poi-3.17.jar
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;
public class readExcel {
public static List<List<String>> readExcle(String fileName) throws Exception {
FileInputStream inputStream = new FileInputStream(fileName);
// 读取工作簿
HSSFWorkbook wb = new HSSFWorkbook(inputStream);
// 读取第一个sheet表格
HSSFSheet sheet = wb.getSheetAt(0);
// 存储sheet表格数据
List<List<String>> sheet_data = new ArrayList<List<String>>();
for (Row row:sheet) {
// 存储行数据
List<String> row_data = new ArrayList<String>();
for (Cell cell:row) {
row_data.add(cell.getStringCellValue().trim());
}
sheet_data.add(row_data);
}
for (int i = 0; i < sheet_data.size(); i++) {
System.out.println("第" + i + "行数据:" + sheet_data.get(i));
}
// 关闭工作簿
wb.close();
return sheet_data;
}
public static void main(String[] args) throws Exception {
readExcle("C:\\Users\\Administrator\\Desktop\\985589.xls");
}
}
源 excel 表格如下:
新表格运行效果图:
IDEA 添加 poi 开源 jar 包演示: