java poi读取excel

最新推荐文章于 2022-06-09 22:26:56 发布

luo381821

最新推荐文章于 2022-06-09 22:26:56 发布

阅读量129

点赞数

CC 4.0 BY-SA版权

文章标签： java

本文链接：https://blog.youkuaiyun.com/luo381821/article/details/118875129

本文介绍了一个Java程序示例，演示了如何使用Apache POI库读取Excel文件(.xls和.xlsx)的内容。该程序能够遍历指定工作表的所有行，并打印单元格的字符串值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.引入依赖

<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi</artifactId>
	<version>3.17</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.17</version>
</dependency>

2.代码示例

package org.test;

import java.io.File;
import java.io.FileInputStream;
import java.util.Iterator;

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;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelTest1 {

	public static void main(String[] args) throws Exception {
		String fileName = "F:\\bak\\v12/test.xlsx";
		FileInputStream fis = new FileInputStream(new File(fileName));
		
		Workbook wb = null;
		if(fileName != null && fileName.matches(".*(\\.xlsx)$")){
			 wb = new XSSFWorkbook(fis);
		}else {
			 wb = new HSSFWorkbook(fis);
		}
		
		Sheet sheet = wb.getSheetAt(0);
		int rowNum = sheet.getLastRowNum();
		Row firstRow = sheet.getRow(0);
		if(firstRow == null) {
			System.out.println("空的excel, 不进行处理.....");
			wb.close();
			fis.close();
			return;
		}
		int cellNum = firstRow.getLastCellNum();
		
		for (int i = 1; i <= rowNum; i++) {
			Row row = sheet.getRow(i);
			if(isEmptyRow(row)) {
				continue;
			}
			
			StringBuilder sb = new StringBuilder();
			for (int j = 0; j < cellNum; j++) {
				Cell cell = row.getCell(j);
				if(cell == null) {
					continue;
				}
				cell.setCellType(CellType.STRING);
				String cellValue = cell.getStringCellValue();
				sb.append(cellValue);
				sb.append("|");
			}
			
			System.out.println(sb.toString());
		}
		wb.close();
		fis.close();
	}
	
	public static boolean isEmptyRow(Row row) {
		if (row == null || row.toString().isEmpty()) {
			return true;
		} else {
			Iterator<Cell> it = row.iterator();
			boolean isEmpty = true;
			while (it.hasNext()) {
				Cell cell = it.next();
				if (cell.getCellTypeEnum() != CellType.BLANK) {
					isEmpty = false;
					break;
				}
			}
			return isEmpty;
		}
	}

}