robot Framework 从excel中读取数据

import xdrlib,xlrd

class Mykey(object):

def _open_excel(self,path)

try:

work_book = xlrd.open_workbook(path,'rb')

except Exception,e:

print str(e)

raise Exception("Can not open work book! Pls check it at path: %s" % path)

return work_book

def _open_sheet_by_index(self,work_book,index):

try:

sheet = work_book.sheet_by_index(index)

except:

raise Exception("Can not open sheet by index %s" % index)

return sheet

def _open_sheet_by_name(self,work_book,sheet_name):

sheet=None

for st_name in work_book.sheet_names():

if str(st_name) == sheet_name:

sheet = work_book.sheet_by_name(sheet_name)

if sheet is None:

raise Exception("Can not open sheet by name %s" % sheet_name)

return sheet

def _get_data_from_sheet(self,sheet,col_index=2):

nrows = sheet.nrows  #行数

print nrows

ncols = sheet.ncols  #列数

if col_index > ncols:

raise Exception("Can not find %d cols from sheet %s" % (col_index, sheet.name))

#        colnames = sheet.row_value(0) #第一行的数据

list1=[]

list2=[]

for rownum in range(1,nrows):

row_col0 = sheet.row(rownum)[0].value

row_col1 = sheet.row(rownum)[1].value

list1.append(row_col0)

list2.append(row_col1)

#            print list2

dict_data = dict(zip(list1,list2))

print dict_data

return dict_data

def _get_testdata_from_sheet(self,sheet,col_index=3):

nrows = sheet.nrows  #行数

print nrows

ncols = sheet.ncols  #列数

if col_index > ncols:

raise Exception("Can not find %dth cols from sheet %s" % (col_index, sheet.name))

list1=[]

list2=[]

for rownum in range(1,nrows):

for colnum in range (0,ncols):

list1.append(sheet.row(rownum)[colnum].value)

list2.append(list1)

list1=[]

print list2

return list2

def get_testdata_from_excel_by_index(self,path,index):

'''

通过sheet index 从excel里读取数据

path excel文件路径，index 第几个sheet

返回数据 数据为字典类型

Example:

|Get Testdata Form Excel By Index | path |index=0|

|Get Testdata Form Excel By Index | text.xls |

'''

work_book = self._open_excel(path)

sheet = self._open_sheet_by_index(work_book,index)

dict_data = self._get_data_from_sheet(sheet)

return dict_data

def get_testdata_from_excel_by_name(self,path,sheet_name=u'Sheet1'):

'''

通过sheetname 从excel里读取数据

path excel文件路径，sheet_name sheet 名字

返回数据 数据为字典类型 用于读取用户数据

Example:

|Get Testdata Form Excel By Index | path |sheet_name=u'Sheet1'|

|Get Testdata Form Excel By Index | text.xls |index=0|

'''

work_book = self._open_excel(path)

sheet = self._open_sheet_by_name(work_book,sheet_name)

dict_data = self._get_data_from_sheet(sheet)

return dict_data

def get_testdata_from_excel(self,path,sheet_name=u'Sheet1'):

'''

从excel里读取数据

path excel文件路径，sheet_name sheet 名字

返回数据 数据为list [[api1,params1,expect1,descript1],[api2,params2,expect2,descript2],[api3,params3,expect3],...]

[api1,params1,expect1,descript1] 相当于一条testcase

Example:

|Get Testdata Form Excel| path |sheet_name=u'Sheet1'|

|Get Testdata Form Excel| text.xls |

'''

work_book = self._open_excel(path)

sheet = self._open_sheet_by_name(work_book,sheet_name)

list_data = self._get_testdata_from_sheet(sheet)

return list_data

以上是从excel读取数据的code，如何自定义关键字？详见robot Framework 自定义关键字

excel表格格式：

UserMgmt_by_gcf.xls

keyworld：

Get Value Testdata From Sheet Name

使用：建.xls放在suit的同级目录下

testcase