java 读取xlsx文件数据_Java读取excel文件数据

packagecom.tc.readexcel.util;importjava.io.File;importjava.io.FileInputStream;importorg.apache.poi.xssf.usermodel.XSSFCell;importorg.apache.poi.xssf.usermodel.XSSFRow;importorg.apache.poi.xssf.usermodel.XSSFSheet;importorg.apache.poi.xssf.usermodel.XSSFWorkbook;public classReadExcelCertainCellForXlsx {/*** 从file表格文件中读取第sheetNum张表单的第row行第column列

*@paramfile

*@paramsheetNum

*@paramrow

*@paramcolumn

*@return

*/

public String getValue(String file, int sheetNum, introw, String column){

File f= newFile(file);

FileInputStream is= null;

XSSFWorkbook wbs= null;

XSSFSheet childSheet= null;try{

is= newFileInputStream(f);

wbs= newXSSFWorkbook(is);

childSheet= wbs.getSheetAt(sheetNum-1);

readExcelCell(childSheet, row, column);

}catch(Exception e) {