pyapacheatlas.readers.excel.ExcelReader.parse_bulk_entities

ExcelReader.parse_bulk_entities(filepath, contacts_func=None)

Generate a set of entities from an excel template file.

Special Headers

• [root] someProperty adds the cell’s value to the root of the entity in the someProperty property.

• [Relationship] meanings add glossary terms

• experts and owners add expert or owner contact.

  • For Microsoft Purview Supports email or email:info when used with contacts_func

  • For Microsoft Purview Supports supports objectId or objectId:info without a contacts_func

  • : is a hard coded delimiter between the email or object id and the info value

  • info is the string of info text for Microsoft Purview

  • Also supports multiple entries using the value separator (defaults to ;) e.g. email1;email2:info2;email3:info3

Parameters

• filepath (str) – The xlsx file that contains your table and columns.

• contacts_func (function) – For Azure Purview, a function to be called on each value when you pass in an experts or owners header to json_rows. Leaving it as None will return the exact value passed in to the experts and owners section. It has a built in cache that will prevent redundant calls to your function.

Returns

An AtlasTypeDef with entityDefs for the provided rows.

Return type

dict(str, list(dict))