[已解决]请帮我看看为什么不能读取文件

ElinaElizabeth

import xlrd
import numpy as np

file_name = xlrd.open_workbook('C:\Users\swift\Desktop\002142.SZ宁波.xlsx')
try:
    im_sheet = file_name.sheet_by_name('Sheet1')
except:
    print('无',format(file_name))
row_num = im_sheet.nrows
col_num = im_sheet.ncols

stdbox=[]
for i in range(1,row_num):
    stdbox.append(im_sheet.cell(i,3))
    if len(stdbox) == 5:
       average = np.mean(stdbox)
       print(average)
       stdbox=[]

最佳答案

月排行榜 / 总排行榜

疾风怪盗

2020-10-17 20:52:40

文件可以读取啊，就是后面需要修改下，获取的是cell的value，而且文件也必须是纯数字，才能用np.mean，否则就是报错

1. import xlrd
   
2. import numpy as np
   
3. 
   
4. file_name = xlrd.open_workbook('1.xlsx')
   
5. try:
   
6.     im_sheet = file_name.sheet_by_name('Sheet1')
   
7. except:
   
8.     print('无',format(file_name))
   
9. row_num = im_sheet.nrows
   
10. col_num = im_sheet.ncols
    
11. 
    
12. stdbox=[]
    
13. for i in range(1,row_num):
    
14.     stdbox.append(im_sheet.cell(i,3).value)
    
15.     if len(stdbox) == 5:
    
16.        average = np.mean(stdbox)
    
17.        print(average)
    
18.        stdbox=[]

复制代码

跳转到最佳答案楼层

疾风怪盗

文件可以读取啊，就是后面需要修改下，获取的是cell的value，而且文件也必须是纯数字，才能用np.mean，否则就是报错

1. import xlrd
   
2. import numpy as np
   
3. 
   
4. file_name = xlrd.open_workbook('1.xlsx')
   
5. try:
   
6.     im_sheet = file_name.sheet_by_name('Sheet1')
   
7. except:
   
8.     print('无',format(file_name))
   
9. row_num = im_sheet.nrows
   
10. col_num = im_sheet.ncols
    
11. 
    
12. stdbox=[]
    
13. for i in range(1,row_num):
    
14.     stdbox.append(im_sheet.cell(i,3).value)
    
15.     if len(stdbox) == 5:
    
16.        average = np.mean(stdbox)
    
17.        print(average)
    
18.        stdbox=[]

复制代码