Excel is a program developed by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.
MANTA can connect to Microsoft Excel, process .xlsm and .xlsx files, and look up Excel objects such as graphs and pivot tables. MANTA also recognizes some tables manually created in sheets. All the mapped objects are then connected with their source objects by analyzing queries with MANTA’s database connectors.
MANTA currently scans
- XLSX, XLSM workbooks
- Defined names
- Pivot tables
- Database connections and queries
Work in progress
An experimental version of the MS Excel scanner is now available.
In future releases, you can expect improved Power Query support for database connections.