code: public function listWorksheetInfo($pFilename)
      {
          File::assertFile($pFilename);
  
          $worksheetInfo = [];
  
          $xml = $this->trySimpleXMLLoadString($pFilename);
  
          $namespaces = $xml->getNamespaces(true);
  
          $worksheetID = 1;
          $xml_ss = $xml->children($namespaces['ss']);
          foreach ($xml_ss->Worksheet as $worksheet) {
              $worksheet_ss = $worksheet->attributes($namespaces['ss']);
  
              $tmpInfo = [];
              $tmpInfo['worksheetName'] = '';
              $tmpInfo['lastColumnLetter'] = 'A';
              $tmpInfo['lastColumnIndex'] = 0;
              $tmpInfo['totalRows'] = 0;
              $tmpInfo['totalColumns'] = 0;
  
              if (isset($worksheet_ss['Name'])) {
                  $tmpInfo['worksheetName'] = (string) $worksheet_ss['Name'];
              } else {
                  $tmpInfo['worksheetName'] = "Worksheet_{$worksheetID}";
              }
  
              if (isset($worksheet->Table->Row)) {
                  $rowIndex = 0;
  
                  foreach ($worksheet->Table->Row as $rowData) {
                      $columnIndex = 0;
                      $rowHasData = false;
  
                      foreach ($rowData->Cell as $cell) {
                          if (isset($cell->Data)) {
                              $tmpInfo['lastColumnIndex'] = max($tmpInfo['lastColumnIndex'], $columnIndex);
                              $rowHasData = true;
                          }
  
                          ++$columnIndex;
                      }
  
                      ++$rowIndex;
  
                      if ($rowHasData) {
                          $tmpInfo['totalRows'] = max($tmpInfo['totalRows'], $rowIndex);
                      }
                  }
              }
  
              $tmpInfo['lastColumnLetter'] = Coordinate::stringFromColumnIndex($tmpInfo['lastColumnIndex'] + 1);
              $tmpInfo['totalColumns'] = $tmpInfo['lastColumnIndex'] + 1;
  
              $worksheetInfo[] = $tmpInfo;
              ++$worksheetID;
          }
  
          return $worksheetInfo;
      }
docs: Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
  
  @param string $pFilename
  
  @throws Exception
  
  @return array