POI显示excel所有的数据,POI显示excel数据,[Java]代码impo
分享于 点击 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(); } } }}
用户点评