- Posts: 1130
- Thank you received: 458
[Script] Kill Microsoft Excel
1 year 10 months ago - 1 year 10 months ago #24328
by prashant
[Script] Kill Microsoft Excel was created by prashant
This is an appreciation post on how powerful AETL is just with the script feature which allows you to run pascal or python script.
I had a package which kept failing because Microsoft excel will go in a loop and not allow me to write files. Script + ChatGPT to resuce, here's a simple python script which does the same ( I am sure pascal script will be smaller
)
I had a package which kept failing because Microsoft excel will go in a loop and not allow me to write files. Script + ChatGPT to resuce, here's a simple python script which does the same ( I am sure pascal script will be smaller
)Code:
import etltools, subprocess
def main():
try:
# Check if Excel is running
if subprocess.call('tasklist /FI "IMAGENAME eq excel.exe" | find /I /C "excel.exe"', shell=True) == 0:
# Excel is running, attempt to kill it
subprocess.run(['taskkill', '/F', '/IM', 'excel.exe'], check=True, stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL)
etltools.SetVariable('excel_status', 'Excel was running and has been terminated.')
else:
# Excel is not running
etltools.SetVariable('excel_status', 'Excel was not running. No action taken.')
Result.Value = 1 # Success in both cases
except subprocess.CalledProcessError as e:
etltools.SetVariable('excel_status', f"Failed to kill Excel: {str(e)}")
Result.Value = 0 # Failure
except Exception as e:
etltools.SetVariable('excel_status', f"An unexpected error occurred: {str(e)}")
Result.Value = 0 # Failure
main()
Last edit: 1 year 10 months ago by prashant.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Administrator
1 year 10 months ago #24338
by prashant
Replied by prashant on topic [Script] Kill Microsoft Excel
Got my answer for a super simple script ! Write to log is awesome and effectivey replacement for 'display' command
Output for below script python script
import etltools
def main():
try:
for i in range(1, 11):
etltools.WriteToLog(f"Number: {i}")
Result.Value = 1 # Indicating success
except Exception as e:
etltools.SetVariable('error_message', str(e))
Result.Value = 0 # Indicating failure
main()
Output for below script python script
import etltools
def main():
try:
for i in range(1, 11):
etltools.WriteToLog(f"Number: {i}")
Result.Value = 1 # Indicating success
except Exception as e:
etltools.SetVariable('error_message', str(e))
Result.Value = 0 # Indicating failure
main()
Please Log in or Create an account to join the conversation.