Forum Discussion

mikileung's avatar
mikileung
Occasional Contributor
4 years ago
Solved

How to empty all the content in a column in excel (Python Script)

Hi,   may I ask how can I clear all the content in a column for excel?    I have created a while loop to input new data for my test, but before another loop I would need to clear all the content ...
  • mikileung's avatar
    mikileung
    4 years ago

    I have used a IF...then...statement for this. 

     

    Data Loop A:

    - user name "table data variables"

    - password "table data variables"

    - enter login SAP

    >>>data loop B:

    >>>>if excel column A (variables) equals to user name (previous data loop), the checkpoint if the page contains column B (variables) 

    - log out SAP

     

    Hope it helps other people