POI显示excel所有的数据代码,Java代码库,德仔网

代码语言

代码分类

【Java】 POI显示excel所有的数据

作者:剑麟 / 发布于2012/5/14/ 607

POI显示excel所有的数据

import java.io.File; 
import java.io.FileInputStream; 
import org.apache.poi.hssf.usermodel.HSSFRow; 
import org.apache.poi.hssf.usermodel.HSSFSheet; 
import org.apache.poi.hssf.usermodel.HSSFWorkbook; 


public class poiDemo { 

public static void main(String[] args) { 
try { 
showExcel(); 
} catch (Exception e) { 
// TODO Auto-generated catch block 
e.printStackTrace(); 
} 
} 
public static  void showExcel() throws Exception { 
HSSFWorkbook workbook=new HSSFWorkbook(new FileInputStream(new File("c:/新建 Microsoft Excel 工作表.xls"))); 
HSSFSheet sheet=null; 
for (int i = 0; i < workbook.getNumberOfSheets(); i++) { 
sheet=workbook.getSheetAt(i); 
for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) { 
HSSFRow row=sheet.getRow(j); 
for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) { 
System.out.print(row.getCell(k)+"\t"); 
} 
System.out.println(); 
} 
} 
} 
} 
</div>
<div></div>
<div></div>
import java.io.File;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;</div>
<div>
public class poiDemo {</div>
<div>public static void main(String[] args) {
try {
showExcel();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void showExcel() throws Exception {
HSSFWorkbook workbook=new HSSFWorkbook(new FileInputStream(new File("c:/新建 Microsoft Excel 工作表.xls")));
HSSFSheet sheet=null;
for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
 sheet=workbook.getSheetAt(i);
 for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) {
HSSFRow row=sheet.getRow(j);
for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) {
System.out.print(row.getCell(k)+"\t");
}
System.out.println();
}
}
}
}
<div></div>

试试其它关键字

　POI　

同语言下

可能有用的

剑麟贡献的其它代码(2)