Forum Discussion

mikileung's avatar
Occasional Contributor
4 years ago

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
    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