""
进行excel 的读操作
"""
import xlrd
class OperationExcel:
def __init__(self,file_name=None,sheet_id=None):
if file_name:
self.file_name = file_name
self.sheet_id = sheet_id
else:
self.file_name="../dataconfig/interface.xlsx"
self.sheet_id=0
self.data = self.get_data()
#获取sheet的内容
def get_data(self):
data = xlrd.open_workbook(self.file_name)
tables = data.sheet_by_index(self.sheet_id)
return tables
#获取行数
def get_lines(self):
tables = self.data
return tables.nrows
#获取单元格内容
def get_cell_value(self,row,col):
tables=self.data
return tables.cell_value(row,col)
if __name__ == '__main__':
opers = OperationExcel()
tables = opers.get_cell_value(1,1)
print(tables)
