JAVA读取Excel文件

jar包下载地址：https://download.csdn.net/download/Spring_East/33142735

import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class XlsFile {
	public static void main(String[] args) throws Exception {
		// 获取文件路径
		ReadXlsFile("D:/FileTest.xls");
	}

	
	public static void ReadXlsFile(String path) throws Exception {
		FileInputStream is = new FileInputStream(path);
		HSSFWorkbook sheets = new HSSFWorkbook(is);// 获取工作表
		System.out.println("共有" + sheets.getNumberOfSheets() + "个sheet工作表");
		// 对工作表进行遍历
		for (int k = 0; k < sheets.getNumberOfSheets(); k++) {
			HSSFSheet sheet = sheets.getSheetAt(k);//获取当前工作表sheet
			int rows = sheet.getPhysicalNumberOfRows();// 获取行数
			
			// sheets.getSheetName(k)获取工作表sheet的名称
			System.out.println(sheets.getSheetName(k) + "    有" + rows + "行");
			List sheetList = new ArrayList();//定义list用来存储excel中的数据
			for (int r = 0; r < rows; r++) {
				HSSFRow row = sheet.getRow(r);//获取行数据

				List rowList = new ArrayList