POI操作Excel

POI是apache提供的开源框架。用来操作Microsoft Office文档。所以下载去官网就OK

1、导入jar

下载解压后：

2、读取Excel文件

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

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.CellType;
import org.apache.poi.ss.usermodel.Row;

public class POIExcelTest {

	public static void main(String[] args) throws FileNotFoundException, IOException {
		String path = "H:\\testSystem题库——测试数据.xls";
		//包装一个Excel对象
		HSSFWorkbook hssfWorkbook = new HSSFWorkbook(new FileInputStream(new File(path)));
		//读取文件第一个sheet标签页
		HSSFSheet sheet = hssfWorkbook.getSheetAt(0);
		for (Row row : sheet) {
			for (Cell cell : row) {
				//判断cell的类型
				if(cell.getCellType() == CellType.NUMERIC) {
					double value = cell.getNumericCellValue();
					System.out.print(value + "----");
				}else if(cell.getCellType() == CellType.STRING) {
					String value = cell.getStringCellValue();
					System.out.print(value + "----");
				}
			}
			System.out.println();
		}
		
	}
	
}