ValueError: Row or column values must be at least 1

xw718

import openpyxl

import os





#定义ok表(整合成结果）
ok=openpyxl.load_workbook("ok.xlsx")
sheet_ok=ok.get_sheet_by_name("ok")
row_ok=sheet_ok.max_row




temp=row_ok


i=1
p=1



for i in range(10):

   
    for p in range(temp):


        print( sheet_ok.cell(p,i).value)



Warning (from warnings module):
  File "C:/Users/Administrator/AppData/Local/Programs/Python/Python37/test.py", line 11
    sheet_ok=ok.get_sheet_by_name("ok")
DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]).
Traceback (most recent call last):
  File "C:/Users/Administrator/AppData/Local/Programs/Python/Python37/test.py", line 33, in <module>
    print( sheet_ok.cell(p,i).value)
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\openpyxl\worksheet\worksheet.py", line 296, in cell
    raise ValueError("Row or column values must be at least 1")
ValueError: Row or column values must be at least 1
1、什么问题？
2、别外请教：电子表格有"--",怎么用if写，去除

塔利班

没用过，问题1感觉不是从0开始数行列的，而是1