These methods are used for updating data links that have already been set by the user in the process file. The functions return a Boolean which is True if they were successful in updating the linked information and False if they were not.
Designer Functions for updating the linked data:
● XLSUpdateStreamSummaryTable() function is used for updating the Stream Summary Data Table on the Excel Spreadsheet it is linked with. Prior to using this function the user needs to set data link information either through the Designer interface or using the COM functions, see Functions for Excel Data Link Variables.
● XLSUpdateComponentPropsTable() function is used for updating the Components Property Data Table on the Excel Spreadsheet it is linked with. Prior to using this function the user needs to set data link information either through the Designer interface or using the COM functions, see Functions for Excel Data Link Variables.
● XLSUpdateEquipmentContentsTable(equipName As String) function is used for updating the Equipment Contents Table (for equipment with name equipName) on the Excel Spreadsheet it is linked with. Prior to using this function the user needs to set data link information either through the Designer interface or using the COM functions., see Functions for Excel Data Link Variables.
● XLSUpdateProcedureOperSeqTable(procName As String) function is used for updating the Procedure Activity Overview Table (for procedure with name procName) on the Excel Spreadsheet it is linked with. Prior to using this function the user needs to set data link information either through the Designer interface or using the COM functions.
Designer Functions for updating accessing the link information:
● These are functions that are used to set / get the excel data link variables that are related to the tables that can be linked with excel. See Functions for Excel Data Link Variables for more details.
Designer Functions for setting preferences in the link data (tables):
● These are functions that are used to set / get the various options regarding the excel tables. See Functions for Excel Data Link Variables for more details.
The ProDesigner COM server includes methods which can facilitate in retrieving lists of various items that are part of a ProDesigner process file. Such item lists may be:
● The list of unit procedures included in a flowsheet
● The list of equipment involved in a flowsheet
● The list of pure components or stock mixtures
● The list of streams coming in or leaving a unit procedure
● The sections of a flowsheet
● The equipment employed in a particular section of the flowsheet,
… etc.
For more information on enumerators see:
● Specifying Enumerator Type IDs