java xssfworkbook_java用XSSFWorkbook实现读写Excel

/*** 读取Excel文件的内容

*@paraminputStream excel文件，以InputStream的形式传入

*@paramsheetName sheet名字

*@return以List返回excel中内容*/

public static List>readExcel(InputStream inputStream, String sheetName) {//定义工作簿

XSSFWorkbook xssfWorkbook = null;try{

xssfWorkbook= newXSSFWorkbook(inputStream);

}catch(Exception e) {

System.out.println("Excel data file cannot be found!");

}//定义工作表

XSSFSheet xssfSheet;if (sheetName.equals("")) {//默认取第一个子表

xssfSheet = xssfWorkbook.getSheetAt(0);

}else{

xssfSheet=xssfWorkbook.getSheet(sheetName);

}

List> list = new ArrayList>();//定义行//默认第一行为标题行，index = 0

XSSFRow titleRow = xssfSheet.getRow(0);//循环取每行的数据

for (int rowIndex = 1; rowIndex < xssfSheet.getPhysicalNumberOfRows(); rowIndex&