System.out.println("请输入您的文件路径:");
Scanner sc = new Scanner(System.in);
String a = sc.nextLine();
synchronized (fileName) {
while("".equals(fileName)){
System.out.println("请输入您的文件路径:");
Scanner sc = new Scanner(System.in);
fileName = sc.nextLine();
sc.close();
}
}
InputStream myxls=new FileInputStream(fileName);
@SuppressWarnings("resource")
XSSFWorkbook wb =new XSSFWorkbook(myxls);
XSSFSheet sheet=wb.getSheetAt(0);//第一个工作表
return sheet.getLastRowNum()+1;
}