Python - Task Scheduler 0x1

Having a frustrating time with scheduling a Python script (C:\Python27\test.py), which has the following code:

import xlrd
import csv
with xlrd.open_workbook('Z:/somefile.xls') as wb:
        sh = wb.sheet_by_index(3)
        with open('Z:/somefile.csv', 'wb') as f:
                c = csv.writer(f)
                for r in range(sh.nrows):
                    c.writerow(sh.row_values(r))

This script is supposed to take worksheet 3 in "somefile.xls" and save it into it's own .csv file. When I run it manually from the Python Shell, it works as intended.

Z:\ is a mapped drive located on an entirely different server.

When I try to run from the Task Scheduler, I keep getting the 0x1 result code. I have the Task set up as the following:

• Run whether user is logged on or not - Do Not Store Password
• Run with highest privileges
• Program/script: python.exe
• Add arguments (optional): "test.py"
• Start in (optional): C:\Python27

I've read quite a few posts, all with different suggestions, none of which worked.

Anyone else run into this situation before?

Jeff

I ran into this a few weeks ago, Task Scheduler can be a real pain!

For whatever reason, I have never been able to get a script to run when the "Run whether user is logged on or not" option is selected. I spent something like 10 hours on the phone with my IT department trying to figure it out. It can't be done. Un-checking that option should then allow your script to run.

I Had the same problem, maybe you can try the following configuration:

• Program/script: C:\Python27\python.exe (Full path of the program executable)
• Add arguments (optional): test.py (Name of the file to run)
• Start in (optional): C:\Python27 (Full path of the folder where the file is)

This configuration works for me. Hope this help.

I had the same problem and tried all the way above but didn't work.

My configuration (like this):

• Program/script: python.exe
• Add arguments (optional): D:\test.py
• Start in (optional): C:\Python37\

Finally, I make out that I read the file in my python script

pd.read_excel("./xlsx/XXX.xlsx")

I thought it will direct to "D:/xlsx/XXX.xlsx" but it didn't. I changed the code in my script:

pd.read_excel("D:/xlsx/XXX.xlsx")

and it works for me.