title: How to Iterate through all the rows of Excel sheet in Robot Framework
body: <p>How to iterate of all the rows of the Excel sheet. ?</p>
  <p>below is my code</p>
  <pre><code>*** 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
  </code></pre>
  <p>it's printing nothing</p>
  <pre><code>PS C:\Users\User\PycharmProjects\RobotFramework\Automation&gt; 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
  </code></pre>
  <p>I tried all the possible ways searched online, and was also unable to get the solution</p>