public static String xlsx2String(File file){
String result = "";
try {
FileInputStream fis = new FileInputStream(file);
StringBuilder sb = new StringBuilder();
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(fis);
//read the sheet
for(int numSheet=0;numSheet<xssfWorkbook.getNumberOfSheets();numSheet++){
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet);
if(xssfSheet ==null){
continue;
}
//read the row
for(int rowNum=0; rowNum<=xssfSheet.getLastRowNum();rowNum++){
XSSFRow xssfRow = xssfSheet.getRow(rowNum);
for(int cosNum=0;cosNum<xssfRow.getLastCellNum();cosNum++){
XSSFCell cell = xssfRow.getCell(cosNum);
sb.append(cell.getStringCellValue());
}
}
}
fis.close();
result +=sb.toString();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return result;
}
java读取excel(xlsx格式)内容为string
最新推荐文章于 2023-07-24 09:40:04 发布