I have looked at both python and TCL but can't get anything to work without runtime errors.
Does anyone have any scripts I would use to simply open an xlsx in a shutdown script.
Question
open excel workbook on shutdown tcl / python
+6- Contributor
I have a routine that writes data into rows in Excel through a workspace runner but once the routine is finished I want FME to open the spreadsheet.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
Hi, you can use in start up:
set filename {yourfilenameinclpath}
set shortname [file attributes $filename -shortname]
exec cmd.exe /k start $shortname &
In a Python shutdown script in Windows the following works:
import os
os.system("Book1.xlsx") # Assuming your filename is Book1.xlsx
If this doesn't work, you can include the "start" word:
import os
os.system("start Book1.xlsx")
If your XLSX is in another directory than your FME script, give it an absolute path.
+6- Contributor
Many thanks for both Gio and JimO's responses. It is now working using the Python script
import os
os.system("Book1.xlsx")