Java用poi读取excel文件-.pdf

《Java用poi读取excel文件-.pdf》由会员分享，可在线阅读，更多相关《Java用poi读取excel文件-.pdf（3页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Java 用 poi 读取 excel 文件POI 是 Apache的一个开源的工具包，可以在Apache的官网下载到 jar 包。在项目库中导入此jar 包如下为简单示例：package POI;import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.util.Iterator;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRow

2、;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.poifs.filesystem.POIFSFileSystem;public class ReadExcel public static void main(String args)try InputStream input=new FileInputStream(D:test.xls);POIFSFileSystem fs=new POIFSFileSy

3、stem(input);HSSFWorkbook wb=new HSSFWorkbook(fs);HSSFSheet sheet=wb.getSheetAt(0);/Iterate over each row in the sheet Iterator rows=sheet.rowIterator();while(rows.hasNext()HSSFRow row=(HSSFRow)rows.next();System.out.println(Row#+row.getRowNum();/Iterate over each cell in the row and print out the ce

4、lls/content Iterator cells=row.cellIterator();while(cells.hasNext()HSSFCell cell=(HSSFCell)cells.next();System.out.println(Cell#+cell.getCellNum();switch(cell.getCellType()case HSSFCell.CELL_TYPE_NUMERIC:System.out.println(cell.getNumericCellValue();break;case HSSFCell.CELL_TYPE_STRING:System.out.println(cell.getStringCellValue();break;case HSSFCell.CELL_TYPE_BOOLEAN:System.out.println(cell.getBooleanCellValue();break;case HSSFCell.CELL_TYPE_FORMULA:System.out.println(cell.getCellFormula();break;default:System.out.println(unsuported sell type);break;catch(IOException ex)ex.printStackTrace();