Excel

Excel is a program developed by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.

IBM Automatic Data Lineage can connect to Microsoft Excel, process .xlsm and .xlsx files, and look up Excel objects such as graphs and pivot tables. Automatic Data Lineage also recognizes some tables created manually in sheets. All the mapped objects are then connected with their source objects by analyzing queries with Automatic Data Lineage’s database connectors.

Automatic Data Lineage currently scans:

• XLSX, XLSM workbooks

  • “strict OOXML" format is not supported

• Sheets

• Defined names

• Charts

• Tables

• Pivot tables

• Database connections and queries including Power Query

Check out the following guides for more details on setting up this scanner.

• Excel Integration Requirements
• Excel Manual Inputs
• Excel Resource Configuration

Extraction and Analysis Phase Scenarios

Extraction Phase

For the extraction phase for Excel, there is only one scenario.

1. Excel ingestion scenario - pulls inputs from git Manta Flow Agent Configuration for Extraction:Git Source or a remote agent filesystem location Manta Flow Agent Configuration for Extraction:Agent Source

Analysis Phase

For the analysis phase for Excel files, there is only one scenario.

1. Excel dataflow scenario — analyzes metadata from the provided Excel files and and saves it in your Automatic Data Lineage metadata repository.