我是新手。我尝试在现有的excel文件中写入数据。当我在robotframework上运行时,它显示“找不到名称为'Write To Excel File'的关键字”。那么,您可以帮我修复代码或给我建议吗?
import xlwt
from xlutils.copy import copy
class Excel(object):
def __init__(self):
print "write to excel file"
def group(self,lst, n):
return ([lst[i:i+n] for i in range(0,len(lst),n)])
def write_to_excel_file(self,filename,content_list):
# Existing Excel File
w = copy(filename)
b = w.get_sheet(0)
# Create an new Excel file and add a worksheet.
#workbook = xlwt.Workbook()
#worksheet = workbook.add_sheet('wb')
#content_lists=[1,1,'hello',2,1,'brother',3,1,'how are you',4,1,'are you good today']
t=self.group(content_list,3)
#print(t)
for item in t:
b.write(int(item[0]), int(item[1]), item[2])
# close work book
w.save(filename)
让我知道这是否适合您
import xlwt
from xlutils.copy import copy
import xlrd
import os.path
class Excel(object):
def __init__(self):
print "write to excel file"
def group(self,lst, size):
return ([lst[i:i+size] for i in range(0, len(lst), size)])
def write_to_excel_file(self,filename,content_list):
if not os.path.exists(filename):
workbook = xlwt.Workbook() # Create an new Excel file and add a worksheet.
worksheet = workbook.add_sheet('wb') #add worksheet
workbook.save(filename)
rb = xlrd.open_workbook(filename,formatting_info=True)
r_sheet = rb.sheet_by_index(0)
r = r_sheet.nrows
wb = copy(rb)
sheet = wb.get_sheet(0)
t=self.group(content_list,3)
for item in t:
sheet.write(int(item[0]), int(item[1]), item[2])
wb.save(filename)
RIDE测试用例
*** Settings ***
Library Collections
Library WriteExcel.Excel
*** Variables ***
*** Test Cases ***
Write Excel Test first
[Tags]
@{content} Create List
Append To List ${content} 15 1 Test Case 1
Append To List ${content} 16 1 Test Case 2
Append To List ${content} 17 1 Test Case 3
Append To List ${content} 18 1 Test Case 4
Write To Excel File test3.xls ${content}
log @${content}
Write Excel Test Second
[Tags]
@{content} Create List
Append To List ${content} 25 1 Test Case 11
Append To List ${content} 26 1 Test Case 12
Append To List ${content} 27 1 Test Case 13
Append To List ${content} 28 1 Test Case 14
Write To Excel File test3.xls ${content}
log @${content}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句