Excel Template Reader

ExcelConfiguration([column_sheet, …])	A configuration utility to understand how your Excel file is structured.
ExcelReader(configuration[, guid])	Read in Excel files that follow the excel template tab structure.

The Excel Reader provides an interface to Excel templates and extracting the content in the standardized Atlas format. That extract can then be uploaded to your Microsoft Purview or Apache Atlas.

Learn more about the Excel Configuration options here: Excel Reader Configuration

ExcelReader.parse_bulk_entities(filepath[, …])	Generate a set of entities from an excel template file.
ExcelReader.parse_entity_defs(filepath)	Read a given excel file that conforms to the excel atlas template and parse the type def tab(s) into a set of entity defs that can be uploaded.
ExcelReader.parse_finegrain_column_lineage(…)	Read a given excel file that conforms to the excel atlas template and parse the columns into column lineages.
ExcelReader.parse_table_lineage(filepath)	Read a given excel file that conforms to the excel atlas template and parse the tables and processes table lineages.
ExcelReader.parse_table_finegrain_column_lineages(…)	Read a given excel file that conforms to the excel atlas template and parse the tables, processes, and columns into table and column lineages.
ExcelReader.parse_update_lineage(filepath)	Read a given excel file that conforms to the excel atlas template and parse the (default) UpdateLineage table into existing process entities.
ExcelReader.parse_column_mapping(filepath)	Read a given excel file that conforms to the excel atlas template and parse the (default) ColumnMapping tab into existing process entities.
ExcelReader.parse_update_lineage_with_mappings(…)	Read a given excel file that conforms to the excel atlas template and parse the (default) UpdateLineage and ColumnMapping tabs into existing process entities.
ExcelReader.parse_classification_defs(filepath)	Read a given excel file that conforms to the excel atlas template and parse the (default) ClassificationDefs tab into classifications.
ExcelReader.make_template(filepath, **kwargs)	Generate an Excel template file and write it out to the given filepath.