Java实现表格(excel)文件的读取操作

java 实现对表格文件的读取操作

---

实现步骤：

1. 下载并导入依赖的包
   下载地址：http://poi.apache.org/download.html
   
   包的导入：
   
   
2. 代码实现

package example;

import java.io.FileInputStream;

import java.io.InputStream;

import java.util.ArrayList;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.apache.poi.ss.usermodel.CellType;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

/**
 * 
 * @author dell
 *
 */

public class readdata {

	static int row = 0;
	static int column = 0;

	public static ArrayList readdata(String path) throws Exception// 读取字符串数据

	{

		XSSFWorkbook workbook;
		XSSFSheet sheet;
		XSSFCell cell;
		ArrayList<ArrayList<String>> xlist = new ArrayList();
		ArrayList list = new ArrayList<>();

		InputStream iStream = new FileInputStream(path);

		workbook = new XSSFWorkbook(iStream);

		sheet = workbook.getSheetAt(0);

		row = sheet.getLastRowNum() + 1;// 获取行数

		column = sheet.getRow(0).getPhysicalNumberOfCells();// 获取列数

		for (int i = 0; i < row; i++) {// 行

			for (int j = 0; j < column; j++) {// 列

				XSSFRow row1 = sheet.getRow(i);

				XSSFCell cell1 = row1.getCell(j); // 获取对应元素

				CellType str0 = cell1.getCellType();

				switch (str0) {

				case STRING: // 字符串类型

					String str = cell1.getStringCellValue();

					list.add(str);

					break;

				case BOOLEAN: // 布尔类型

					boolean str1 = cell1.getBooleanCellValue();

					list.add(str1);

					break;

				case NUMERIC: // 数值类型

					double str2 = cell1.getNumericCellValue();

					list.add(str2);

					break;

				}

			}
			xlist.add(list);
			list = new ArrayList<>();

		}

		return xlist;

	}

}

package example;

import java.util.ArrayList;
/**
 * @author dell
 */
public class Main {
	/**
	 * @param args
	 * @throws Exception 
	 */
	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
			ArrayList list=new ArrayList();
			String path0="test.xlsx";
			list=readdata.readdata(path0);
			for(int i=0;i<list.size();i++){
				System.out.println(list.get(i));
			}
	}
}

3. 参考链接
   link1: 依赖包的下载导入
   link2: 对表格的操作