Question

java l 获取excel 总共有几个sheet csdn

Answer 1

public class Test {
public void ExcelSheet() {
InputStream input = new FileInputStream("文件路径");
if(文件名.endsWith(".xls")){
HSSFWorkbook workbook = new HSSFWorkbook(input);
for(int i=0;i<workbook.getNumberOfSheets();i++){
list.add(workbook.getSheetName(i));//获取sheet数据
打印list长度即sheet数目,也可获得内容，
workbook.getNumberOfSheets();也可以获得长度
}
}else if(excelFileStr.endsWith(".xlsx")){
XSSFWorkbook workbook = new XSSFWorkbook(input);
for(int i=0;i<workbook.getNumberOfSheets();i++){
list.add(workbook.getSheetName(i));
打印list长度即sheet数目
}
}
if(input != null) {
input.close();
}
}
}