public static void operateAATP(String aatpPath) throws FileNotFoundException, IOException { XSSFWorkbook aatpExcel = new XSSFWorkbook(new FileInputStream(aatpPath)); XSSFSheet sheet = aatpExcel.getSheetAt(0); XSSFRow row = sheet.getRow(1); //读取第二行的列数 //总行数 int trLength = sheet.getLastRowNum(); //总列数 int tdLength = row.getLastCellNum(); //循环读取 for(int i=0;i