|
By default, the program creates the script_python.py and resultat.txt files next to the excel workbook containing the python code. Then it launches them with python.exe followed by the full name of the script. In the end, the program deletes both of these files.
You can change this behavior by using the options at the top of the tab:
Executable: you can put the full path if python is not in the user's PATH
other directory than the one you are using
filename py: other than script_python.py
filename result: other than resultats.txt
delete files after processing: true/false
Another possibility: work via the form. If you're using an xlsx file, you can't put vba code inside it. Also, via the insert menu button: 
You then have the launch a script tab which will list all the workbooks having a script and for a chosen workbook, all the tabs having a script.
The parameters marked on the tab in the range C2:C6 are displayed. You can modify them if necessary and click on “validate parameters” to modify the values ??on the tab.
By clicking on “launch script”, it is executed. On the right, there is the result with what there are columns i and j if it is ok. Otherwise, the errors of the python program are displayed.
|
Up