java读取excel数据

来源：互联网发布：ubuntu 关闭桌面编辑：程序博客网时间：2024/05/16 05:20
package com.test;import java.io.FileInputStream;import java.io.InputStream;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class Test {public static void main(String[] args) throws Exception {new Test().readXls("E:\\doc\\test.xls");}/** * 读取office2003版的excel文件（.xls） *  * @param filePath * @throws Exception * @Author SevenWong */public void readXls(String filePath) throws Exception {InputStream is = new FileInputStream(filePath);HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);HSSFSheet hssfSheet = null;HSSFRow hssfRow = null;String content;// sheet 数量for (int numSheet = 0, numOfSheets = hssfWorkbook.getNumberOfSheets(); numSheet < numOfSheets; numSheet++) {hssfSheet = hssfWorkbook.getSheetAt(numSheet);if (hssfSheet == null) {continue;}// 从 sheet 中迭代每行的数据for (int rowNum = 2, lastRowNum = hssfSheet.getLastRowNum(); rowNum <= lastRowNum; rowNum++) {hssfRow = hssfSheet.getRow(rowNum);for (int j = hssfRow.getFirstCellNum(), cells = hssfRow.getPhysicalNumberOfCells(); j < cells; j++) {content = hssfRow.getCell(j).toString().trim();System.out.print(content + "\t");}System.out.println();}}hssfWorkbook.close();}/** * 读取office2007版的excel文件（.xlsx） *  * @param filePath * @throws Exception * @Author SevenWong */public void readXlsx(String filePath) throws Exception {// 构造 XSSFWorkbook 对象，filePath 传入文件路径XSSFWorkbook xwb = new XSSFWorkbook(filePath);// 读取第一张sheet表格内容XSSFSheet sheet = xwb.getSheetAt(0);XSSFRow row;String content;// 循环输出表格中的内容// i从真实数据行for (int i = (sheet.getFirstRowNum() + 2), rows = sheet.getPhysicalNumberOfRows(); i < rows; i++) {row = sheet.getRow(i);for (int j = row.getFirstCellNum(), cells = row.getPhysicalNumberOfCells(); j < cells; j++) {// 通过 row.getCell(j).toString() 获取单元格内容，content = row.getCell(j).toString().trim();System.out.print(content + "\t");}System.out.println();}xwb.close();}}
0 0