package com.wc.excel;import java.io.File;import java.io.IOException;import org.apache.commons.io.FileUtils;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 PoiReadExcel {/** * POI解析文件内容 * @author wc * @param args */public static void main(String[] args) {//需要解析的Excel文件File file=new File ("D:/ii.xls");try {HSSFWorkbook workbook =new HSSFWorkbook(FileUtils.openInputStream(file)); //获取第一个工作表 HSSFSheet sheet = workbook.getSheet("sheet0"); //读取默认第一个工作页 //HSSFSheet sheet= workbook.getSheetAt(0); int firstRowNum = 0; //获取sheet中最后一行行号 int lastRowNum = sheet.getLastRowNum(); for (int i = firstRowNum; i <= lastRowNum; i++) {HSSFRow row = sheet.getRow(i);//获取当前行最后单元格列号int lastCellNum = row.getLastCellNum();for (int j = 0; j < lastCellNum; j++) {HSSFCell cell= row.getCell(j);String value =cell.getStringCellValue();System.out.print(value+" ");}System.out.println();}} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();} }}
java POI解析Excel
最新推荐文章于 2024-07-16 15:48:46 发布