import java.io.*; 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 POIExceldc { public static void main(String[] args) throws IOException { //需要解析的文件 File file=new File("d:/learn/poidr.xls"); //创建Excel,读取文件内容 HSSFWorkbook workbook=new HSSFWorkbook(FileUtils.openInputStream(file)); //第一种方法,获取第一张工作表,名字为sheet0,workbook.getSheet("sheet0") //HSSFSheet sheet=workbook.getSheet("sheet0"); //第二种方法,获取第一张工作表,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(); } } }
原文:http://www.cnblogs.com/wangxiaoqun/p/6347000.html