1.需要使用库:ExcelLibrary
若未安装,可以直接通过命令安装:pip install robotframework-ExcelLibrary
2.将要读取的Excel另存为.xls文件,只支持这种.xls文件!!!
3.写用例
*** Settings ***
Library ExcelLibrary
*** Test Cases ***
test1
[Documentation] 1.循环读取excel中的某列数据
log ---------1.open excel-----
open excel F:\0.STUDY-WP\study-rf\user.xls
log ------2.读取某个表格中的值------
${test} read cell data by name userlog A2
log ${test}
log ------3.读取表格中某列的值------
@{read_columnA} get_column_values userlog 0
@{read_columnB} get_column_values userlog 1
${y} set_Variable 1
${count_row} get_row_count userlog
log ${count_row}
FOR ${x} IN RANGE ${count_row}
${a} set_variable KaTeX parse error: Expected '}', got 'EOF' at end of input: {read_columnA[{x}][${y}]}
${b} set_variable KaTeX parse error: Expected '}', got 'EOF' at end of input: {read_columnB[{x}][${y}]}
END