ExcelProfileManager

class profiles.excelprofilemanager.ExcelProfileManager(source_profile=None)

ExcelProfileManager: manages profile data that can be loaded from and saved to excel.

ExcelProfileManager is a subclass of ProfileManager, so it also provides functionality to convert from/to different ESDL profiles and to load/save to CSV

__init__(source_profile=None)

Constructor of the ExcelProfileManager

Parameters:

source_profile – the source profile of which the data is copied into this profiles manager instance

load_excel(file_path, sheet_name: str | None = None)

Reads profile data from an Excel file.

Parameters:

• file_path – the path to the Excel file

• sheet_name – the name of the sheet that contains the data. By default, the first sheet is used

save_excel(file_path, sheet_name: str = 'Sheet1')

Saves profile data to an Excel file.

Parameters:

• file_path – the path to the Excel file

• sheet_name – the name of the sheet that should be created to store the data (default is “Sheet1”)