phpxlsx provides methods to get information from cell positions and XLSX files. These methods can be used combined with other methods of phpxlsx to generate flexible tasks based on the existing contents in a spreadsheet.
Indexer parses the contents of an XLSX file and returns an array with information such as sheet names, properties, comments, links, images, table names and many other useful details about the spreadsheet.
The following sample code calls Indexer to get information from an XLSX file:
The getCell method returns null if the cell position doesn't exist in the sheet.