Invoking python script inside a "use excel file" activity

Help Studio
, ,
1

I have a python file that I am able to successfully run in an “Invoke Python Script”. However, when I place the invoke activity inside both the “Python Scope” and a “Use Excel File Activity” and “Excel Scope” it freezes. Probably too resource intensive. I am connecting to Excel via ODBC. Is there a way to make this work? Or do I need to close & exit “Use Excel File” activity invoke the python and get results and then reenter the “Use Excel File” activity?

1 Like
3

@Phil_Kelsey

Check the cpu usage at that point and see if it is really rwsource intensive…

And if ypu are connecting to excel as DB then ideally you do not need use excel file activity at all…as the connection is done through db activities

Can you please clarify on the same

Cheers

4

@Phil_Kelsey

  1. you can resolve the resource-intensive issue by moving the Invoke Python Script activity outside the Use Excel File activity and process the Excel file before and after invoking the Python script . as this approach would require proper handling of resources and file interactions.

cheers…!

5

that appears to work. I completely removed all my database activities (database connect, execute query) and Python activities out of the Excel scope and Use Excel File activities which I kept for other purposes. The subsequent ODBC connection creates a datatable that I iterate each time calling the Python method. I update the worksheet with dml using a pk.

1 Like
6

thanks. that worked to move the Python activities out

7

@Phil_Kelsey

thank u

cheerss…!

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.