时间戳

首页 > 解决方案 > 如何在机器人框架中遍历 Excel 工作表的所有行

python-3.x - 如何在机器人框架中遍历 Excel 工作表的所有行

问题描述

如何迭代 Excel 工作表的所有行。?

下面是我的代码

*** Settings ***
Library           SeleniumLibrary
Library           ExcelLibrary
Library           Collections

*** Variables ***
${path_excel}   C:\\User\\Test.xlsx



*** Test Cases ***
Test1
    Test the ExcelData

*** Keywords ***


Test the ExcelData
    ${my_data_as_list}=    Create List
    #open the Excel  ${path_excel}
    open excel document   filename=${path_excel}  doc_id=Sheet2
    
    FOR   ${i}   IN  20
      ${my_data}=  Read Excel Cell  row_num=${i}  col_num=1
       Log to Console  ${my_data}
      Append To List    ${my_data_as_list}      ${my_data}

    Log to Console   ${my_data_as_list}
    END

它什么也没打印

PS C:\Users\User\PycharmProjects\RobotFramework\Automation> robot .\ExcelExtract.robot
==============================================================================
ExcelExtract
==============================================================================
Test1                                                                 None
[None]
Test1                                                                 | PASS |
------------------------------------------------------------------------------
ExcelExtract                                                          | PASS |
1 test, 1 passed, 0 failed
==============================================================================
Output:  C:\Users\User\PycharmProjects\RobotFramework\Automation\output.xml
Log:     C:\Users\User\PycharmProjects\RobotFramework\Automation\log.html
Report:  C:\Users\User\PycharmProjects\RobotFramework\Automation\report.html

我尝试了所有可能的在线搜索方法，也无法得到解决方案

标签： python-3.xexcelrobotframework

解决方案

请
FOR ${i} IN 20
改为
FOR ${i} IN RANGE 1 20

推荐阅读