使用POI读取EXCEL中的所有Sheet表
最近接触到了多sheet页的导入导出功能,现举例如何 使用POI,通过多个循环读取EXCEL中的所有Sheet表内容。
package poitest;
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 getAllExcelData {
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("/file/student.xls")));
HSSFSheet sheet=null;
for (int i = 0; i < workbook.getNumberOfSheets(); i++) {//获取每个Sheet表
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("---Sheet表"+i+"处理完毕---");
}
}
}
}