返得利购物, 淘宝,京东500家商城合作,包含全面的商城返利网。注册就送5元,购物就有返利。随时提现。 同学们,新一轮的返利大潮正在慢慢靠近,让购物都觉得自己在赚钱,购物,机票,游戏,酒店旅游,地方特色,娱乐,尽在www.bbuy8.com让你购物省钱,省心。【群号:335156195】
public static void main(String[] args) {
try {
//从流读取文件
InputStream input = new FileInputStream("D:\\FILE_TMP\\水电煤数据.xls");
POIFSFileSystem fs = new POIFSFileSystem(input);
HSSFWorkbook wb = new HSSFWorkbook(fs);
//得到第一页
HSSFSheet sheet = wb.getSheetAt(1);
// Iterate over each row in the sheet
//获取有多少行
Iterator rows = sheet.rowIterator();
//循环
while (rows.hasNext()) {
HSSFRow row = (HSSFRow) rows.next();
// if(0==row.getRowNum())
// {
// continue;
// }
System.out.println("Row #" + row.getRowNum());
Iterator cells = row.cellIterator();
while (cells.hasNext()) {
HSSFCell cell = (HSSFCell) cells.next();
// System.out.print("Cell #" + cell.getCellNum());
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.println(cell.getBooleanCellValue()+"\t");
break;
case HSSFCell.CELL_TYPE_FORMULA:
Systelt:
System.out.print("unsuported sell type");
break;
}
}
}
} catch (IOException ex) {
ex.printStackTrace();
}
}