Using an Excel Application scope through invoked workflows

Perhaps this has been asked in a previous post, could not find any though.

It happens that we’re in the need of writing/reading data to/from Excel files several times in different, connected, workflows. It seems that the workbook cannot be passed to be reused. Is this by design or how is this intendended to be used in practice?

Thanks

// André

You can use the ExistingWorkbook property of the Excel Application Scope activity to save the workbook to a variable and pass it to other workflows as an argument.
Example: WorkbookArgument.zip (11.0 KB)

1 Like

Sorry for the late reply.

Thanks for clarifying the usage.

Although, doing a similar approach in 2018.4 yields another result it seems.

Any thoughts on performance in your experience? As compared not reusing the workbook?

Regards André