如何迭代 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
網上搜索的各種方法都試過了，也沒有找到解決辦法
uj5u.com熱心網友回復：
請
FOR ${i} IN 20
改為
FOR ${i} IN RANGE 1 20
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/321465.html
下一篇：檢測單元格值已更改VBA