java excel解析类,Java 解析excel文件

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

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

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

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

public class ExcelService {

/**

* 解析excel文件

* @param file

* @return

*/

public static void getExcelInfo(String file){

try {

InputStream is = new FileInputStream(file);

XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is);

XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0);

for (int rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++) {

XSSFRow xssfRow = xssfSheet.getRow(rowNum);

if (xssfRow != null) {

System.out.println(xssfRow.getCell(0).toString());

System.out.println(xssfRow.getCell(1).toString());

System.out.println(xssfRow.getCell(2).toString());

System.out.println(xssfRow.getCell(3).toString());

}

}

} catch (FileNotFoundException ecp){

System.out.println("FileNotFoundException");

} catch (IOException ecp){

System.out.println("IOException");

}

}

}