Scanners & integrations
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.
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.
MANTA currently scans:
- XLSX, XLSM workbooks
- Defined names
- Pivot tables
- Database connections and queries