欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

POI显示excel所有的数据,POI显示excel数据,[Java]代码impo

来源: javaer 分享于  点击 38826 次 点评:161

POI显示excel所有的数据,POI显示excel数据,[Java]代码impo


[Java]代码

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();            }    }    }}
相关栏目:

用户点评