[問題] python載入excel
上網爬文說要載入xlrd套件
載入套件之後，開始要載入excel時程式碼出現一些問題
想請高人指點一下，小弟我感激不盡
---以下是我的程式碼---
import xlrd
data = xlrd.open_workbook('B18.xlsx')
table = data.sheets()[0]
nrows = table.nrows
ncols = table.ncols
colnames = table.row_values(colnameindex)
list =[]
for rownum in range(1,nrows):
row = table.row_values(rownum)
if row:
app = {}
for i in range(len(colnames)):
app[colnames[i]] = row[i]
list.append(app)
return list
--以下是我執行.py檔時出現的錯誤--
http://imgur.com/a/OEpEr
初學python請大家多多指教
也請大家鞭小力一點
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.34.109.96
※ 文章網址: https://www.ptt.cc/bbs/Python/M.1479542024.A.5A8.html
推
11/19 20:09, , 1F
11/19 20:09, 1F
→
11/19 20:12, , 2F
11/19 20:12, 2F
→
11/19 20:12, , 3F
11/19 20:12, 3F
→
11/20 00:15, , 4F
11/20 00:15, 4F
→
11/20 12:46, , 5F
11/20 12:46, 5F
→
11/20 12:46, , 6F
11/20 12:46, 6F
推
11/20 13:58, , 7F
11/20 13:58, 7F
→
11/20 15:49, , 8F
11/20 15:49, 8F
→
11/20 17:11, , 9F
11/20 17:11, 9F
→
11/20 17:11, , 10F
11/20 17:11, 10F
→
11/20 17:11, , 11F
11/20 17:11, 11F
→
11/20 17:21, , 12F
11/20 17:21, 12F
→
11/20 17:21, , 13F
11/20 17:21, 13F
→
11/20 17:22, , 14F
11/20 17:22, 14F
→
11/20 18:46, , 15F
11/20 18:46, 15F
→
11/20 18:46, , 16F
11/20 18:46, 16F
→
11/20 18:46, , 17F
11/20 18:46, 17F
→
11/21 10:34, , 18F
11/21 10:34, 18F
→
11/21 19:02, , 19F
11/21 19:02, 19F
→
11/21 19:02, , 20F
11/21 19:02, 20F
→
11/21 19:02, , 21F
11/21 19:02, 21F
Python 近期熱門文章
PTT數位生活區 即時熱門文章