java利用poi读取excel_java利用poi读取excel

先下载poi包导入工程

直接贴代码了

package 读EXCEL文档;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadExcel {

public static void main(String[] args) {

String fileName = "C:\\Users\\ct\\Desktop\\my.xlsx" ;// jxl包不支持excel2010,这里会报错

File file = new File(fileName);

Workbook wb;

try {

//通过文件输入流建立EXCEL工作薄

wb = new XSSFWorkbook(new FileInputStream(file));

Sheet sheet = wb.getSheetAt(0);

System.out.println("sheet name : " + sheet.getSheetName());//工作表的名称

System.out.println("sheet row num : " + sheet.getPhysicalNumberOfRows());//表格中有多少行

int j = 0 ;

for(int i=0;i<=sheet.getLastRowNum();i++)

{

XSSFRow row = (XSSFRow) sheet.getRow(i);

//System.out.println(row.getPhysicalNumberOfCells());//一行有多少列

for(j=0 ; j

XSSFCell cell = row.getCell(j);

switch(cell.getCellType()){//要先判断数据类型

case XSSFCell.CELL_TYPE_STRING:

System.out.print(cell.getStringCellValue()+" ");

break;

case XSSFCell.CELL_TYPE_NUMERIC:

System.out.print(cell.getNumericCellValue()+" ");

break;

case XSSFCell.CELL_TYPE_BLANK:

break;

case XSSFCell.CELL_TYPE_BOOLEAN:

break;

case XSSFCell.CELL_TYPE_ERROR:

break;

case XSSFCell.CELL_TYPE_FORMULA:

break;

}

}

System.out.println();

}

} catch (IOException e) {

e.printStackTrace();

}

}

}