SOAtest: Call Excel application from Extension Tool

dgoedh

Hi,

In order to recalculate the formulas in our Excel datasource, we need MS Excel to open en save the workbook before running the test. This can be accomplished by calling an external bat script, but this not preferred, from maintenance perspective.
With jython/java I need the 'os' class in order to use e,g, win32com.client method for kicking off Excel, or any other external app. However this does NOT seem to be part of the standard library installation of SOAtest. Is there a way to add this 'os' class to SOAtest, e.g. by adding a jar to the System Properties?

Or can this functionality only be accomplished by creating a new building block in java?

Thanks is advance.

Regards,

Daniel

dgoedh

Or maybe External Tool is better for this task at hand?

benken_parasoft

However this does NOT seem to be part of the standard library installation of SOAtest. Is there a way to add this 'os' class to SOAtest

See my answer in this other thread:
How do I import modules for Extension Tool in Jython