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 org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class ReadE {
public static void main(String[] args) {
try {
InputStream input = new FileInputStream("demo.xls");//这里修改文件路径
POIFSFileSystem fs = new POIFSFileSystem(input);
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);//这里修改工作簿
Iterator rows = sheet.rowIterator();
while (rows.hasNext()) {
HSSFRow row = (HSSFRow) rows.next();
Iterator cells = row.cellIterator();
while (cells.hasNext()) {
HSSFCell cell = (HSSFCell) cells.next();
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:
System.out.print(cell.getNumericCellValue()+"\t");
break;
case HSSFCell.CELL_TYPE_STRING:
System.out.print(cell.getStringCellValue()+"\t");
break;
case HSSFCell.CELL_TYPE_BOOLEAN:
System.out.print(cell.getBooleanCellValue()+"\t");
break;
case HSSFCell.CELL_TYPE_FORMULA:
System.out.print(cell.getCellFormula()+"\t");
break;
default:
System.out.print("unsuported sell type"+"\t");
break;
}
}
System.out.println();
}
} catch (IOException ex) {
ex.printStackTrace();
}
}
}
简单 的java 读取 excel
最新推荐文章于 2023-01-13 19:47:09 发布