Database.read_add_sectors_excel(

path,

get_inventories=False,

read_inventories=False,

split=False,

)

Read add-sectors workbook inputs and attach their metadata to the database.

Parameters:

• path – Path to one add-sectors workbook. When read_inventories=True, a directory containing multiple workbooks is also supported.

• get_inventories – When True, create any missing inventory-sheet templates in the workbook after reading the master sheet.

• read_inventories – When True, also read and group the inventory sheets referenced by the workbook.

• split – When True, parse the split-support sheets required by IOT add-sectors workbooks. When False (default), skip those sheets even if the master contains rows marked Split.

Returns:

Workbook metadata is stored on the current instance.

Return type:

None

Notes

The method always stores the normalized master sheet, cluster maps and derived item sets on the database instance. When read_inventories=True it also groups the inventory sheets by target item and stores them on self.inventories.