Excel Functions

These functions are used for accessing the Ebsilon Standard Excel Interface. Functions for the user-defined Excel Interface are described in External I/O Functions.

Note that for the Standard Excel Interface, the file name ("<modelname>.xls"), the folder (the same as that of the corresponding ebs-file) and the layout are already defined.

All these functions have an optional argument "onlyActiveProfile". The default value of this argument is "true". For this reason, each function call will act only on the active profile without this argument. If you wish to include all profiles, you must specify the value as "false".

The "Write" function creates the Excel Workbook, if it does not already exist. If necessary, additional sheets are inserted in this workbook. Existing sheets are not deleted.

Excel works in the background, while EbsScript executes the applications. To view the workbook, click on the button "Open Workbook" after the calculation.

Name	Purpose	Arguments	Return value	Example
readCompProfilesFromExcel	Reads the values of the specified components from the Excel Workbook.	1: STRING: Constants: Component name 2: BOOLEAN: (optional): if true, only the active profile is written, if false, all profiles are written	BOOLEAN: True, if OK	readCompProfilesFromExcel ("MDT_5");
readProfilesFromExcel	Reads values from the Excel workbook. Which components are read, depends on the settings made in the Model Options and in the “write-to-Excel flag” in the component property sheets.	1: BOOLEAN: (optional): if true, only the active profile is written, if false, all profiles are written	BOOLEAN: True, if OK	readProfilesFromExcel;
writeCompProfilesToExcel	Writes the values of the specified components in the Excel workbook. In addition, the sheets "Model”, “Pipelines” and "Texts” are written.	1: STRING: Constants: Component name 2: BOOLEAN: (optional): if true, only the active profile is written, if false, all profiles are written	BOOLEAN: True, if OK	writeCompProfilesToExcel ("Generator"); writeCompProfilesToExcel ("Generator", false);
writeProfilesToExcel	Writes values in the Excel workbook. Which components are written, depends on the settings made in the Model Options and in the “write-to-Excel flag” in the component property sheets.	1: BOOLEAN: (optional): if true, only the active profile is written, if false, all profiles are written	BOOLEAN: True, if OK	writeProfilesToExcel;

Impressum Disclaimer