没有名称' gspread'
下面的文件直接在控制台上运行时成功运行,但给出一个错误:在服务器上没有名为“ gspread”的模块
import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint
class GoogleSheet():
scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
#creds = ServiceAccountCredentials.from_json_keyfile_name("creds.json", scope)
creds = gspread.service_account()
#client = gspread.authorize(creds)
sh = creds.open("DI ITEM SHEET") # Open the spreadhseet
wks = sh.worksheet("2022-APR") # Open the workhseet
data = wks.get_all_records()
Below file runs successfully when run direct on the console, but give an error: No module named 'gspread' on server
import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint
class GoogleSheet():
scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
#creds = ServiceAccountCredentials.from_json_keyfile_name("creds.json", scope)
creds = gspread.service_account()
#client = gspread.authorize(creds)
sh = creds.open("DI ITEM SHEET") # Open the spreadhseet
wks = sh.worksheet("2022-APR") # Open the workhseet
data = wks.get_all_records()
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论