运行Python程序时出错（Newbie）

Question

如果有这样的话题，我很抱歉，但我找不到答案。所以，让我们开始吧：有人为我创建了这样一个代码，但不幸的是，他没有告诉我如何运行它和混乱本身，而不是写回。我试图自己解决问题，但不幸的是，我的知识还没有达到这个水平。当我试图在VSC中启动代码时，我看到了这样一个错误

c:\Users\XXX\AppData\Local\Programs\Python\Python36-32\Scripts>main.py
dane.xlsx
Traceback (most recent call last):
File "C:\Users\XXX\AppData\Local\Programs\Python\Python36-32\Scripts\main.py",line 21, in <module>
if __name__ == "__main__": main()
File "C:\Users\XXX\AppData\Local\Programs\Python\Python36-32\Scripts\main.py", line 8, in main
xl = pd.ExcelFile(input("dane.xlsx"))
File "C:\Users\XXX\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\excel.py", line 394, in __init__
self.book = xlrd.open_workbook(self._io)
File "C:\Users\XXX\AppData\Local\Programs\Python\Python36-32\lib\site-packages\xlrd\__init__.py", line 116, in open_workbook
with open(filename, "rb") as f:
FileNotFoundError: [Errno 2] No such file or directory:

这里我给出了两个文件的代码，可能其中有一个错误： 主.py在

^{pr2}$

在可湿性粉剂在

from datetime import datetime
import time


def get_time():
return str(datetime.now().strftime('[%H:%M:%S] '))




class wp():

def __init__(self,driver,base_url):
    self.base_url = base_url
    self.login = "xxx"
    self.password = "xxx"
    self.driver = driver

def _login(self):
    self.driver.get(self.base_url+"/wp-login.php")

    self.driver.find_element_by_id("user_login").send_keys(self.login)
    self.driver.find_element_by_id("user_pass").send_keys(self.password)

    self.driver.find_element_by_id("wp-submit").click()


def _send_data(self,title,content,date,logo,medium,link,linka):
    self.driver.get(self.base_url+"/wp-admin/post-new.php")
    self.driver.find_element_by_id("title").send_keys(title)
    self.driver.find_element_by_id("content").send_keys(content)

    self.driver.execute_script("document.getElementsByClassName('edit-timestamp hide-if-no-js')[0].click();")

    date = date.split(".")
    if date[1][0:1] == "0": date[1] = date[1][1:2]

    self.driver.find_element_by_id("jj").send_keys(date[0])
    self.driver.find_element_by_xpath('//*[@id="mm"]/option['+date[1]+']').click()
    self.driver.find_element_by_id("aa").send_keys(date[2])


    self.driver.execute_script("document.getElementsByClassName('save-timestamp hide-if-no-js button')[0].click();")
    self.driver.execute_script("document.getElementById('set-post-thumbnail').click();")

    self.driver.execute_script("document.getElementById('media-search-input').value='"+medium+"';")

    time.sleep(1)

    self.driver.execute_script("document.getElementsByClassName('thumbnail')[0].click();")

    self.driver.execute_script("document.getElementsByClassName('button media-button button-primary button-large media-button-select')[0].click();")





    self.driver.execute_script("document.getElementById('insert-media-button').click();")


    self.driver.execute_script("document.getElementsByClassName('search')[1].value='"+logo+"';")

    time.sleep(1)

    self.driver.execute_script("document.getElementsByClassName('attachments ui-sortable ui-sortable-disabled')[1].getElementsByClassName('thumbnail')[0].click();")
    time.sleep(1)

    self.driver.execute_script("document.getElementsByClassName('media-sidebar visible')[0].getElementsByTagName('input')[1].value='"+link+"';")
    self.driver.execute_script("document.getElementsByClassName('media-sidebar visible')[0].getElementsByTagName('input')[2].value='"+link+"';")
    self.driver.execute_script("document.getElementsByClassName('media-sidebar visible')[0].getElementsByTagName('textarea')[1].value='"+link+"';")

    self.driver.execute_script("document.getElementsByClassName('attachment-display-settings')[0].getElementsByTagName('input')[0].value='"+linka+"';")
    time.sleep(1)

    self.driver.execute_script("document.getElementsByClassName('button media-button button-primary button-large media-button-insert')[0].click();")

    self.driver.execute_script("document.getElementById('publish').click();")
    time.sleep(1)

我提前为模棱两可的问题道歉，谢谢你的帮助

Answer 1

因为您可能正在尝试硬编码文件路径而不请求用户输入（input()），所以您可能应该替换

xl = pd.ExcelFile(input("C:\Praca\dane.xlsx"))

与

^{pr2}$

Answer 2

脚本要查找的文件不存在。在您的示例中，您执行了主.py从目录“c:\Users\XXX\AppData\Local\Programs\Python\Python36-32\Scripts”。所以，”丹麦.xlsx目录“c:\Users\XXX\AppData\Local\Programs\Python\Python36-32\Scripts”中不存在。您可以将其移动到那里，也可以输入到的完整路径丹麦.xlsx，而不仅仅是文件名。在