Java用poi读取excel文件

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;import o

2、rg.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 POIFSFileSyst

3、em(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

4、and print out the cells / 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.printl