try {
FileInputStream infile = new FileInputStream("D:\\Book1.xls");
POIFSFileSystem poiFs = new POIFSFileSystem(infile);
HSSFWorkbook wb = new HSSFWorkbook(poiFs);
HSSFSheet sheet = wb.getSheetAt(0); for (int j = 1; j <= sheet.getLastRowNum(); j++) {
HSSFRow row = sheet.getRow(j);
System.out.println("this line is:");
for (int i = 1; i < row.getLastCellNum(); i++) {
HSSFCell cell = row.getCell((short) i); System.out.println(" value="+ this.getStringCellValue(cell));
}
}
int rowNumber = sheet.getFirstRowNum();
//System.out.println("rowNumber=" + rowNumber);
int lastRowNumber = sheet.getLastRowNum();
//System.out.println("lastRowNumber=" + lastRowNumber); } catch (Exception e) {
e.printStackTrace();
}
FileInputStream infile = new FileInputStream("D:\\Book1.xls");
POIFSFileSystem poiFs = new POIFSFileSystem(infile);
HSSFWorkbook wb = new HSSFWorkbook(poiFs);
HSSFSheet sheet = wb.getSheetAt(0); for (int j = 1; j <= sheet.getLastRowNum(); j++) {
HSSFRow row = sheet.getRow(j);
System.out.println("this line is:");
for (int i = 1; i < row.getLastCellNum(); i++) {
HSSFCell cell = row.getCell((short) i); System.out.println(" value="+ this.getStringCellValue(cell));
}
}
int rowNumber = sheet.getFirstRowNum();
//System.out.println("rowNumber=" + rowNumber);
int lastRowNumber = sheet.getLastRowNum();
//System.out.println("lastRowNumber=" + lastRowNumber); } catch (Exception e) {
e.printStackTrace();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货