Forum Discussion

mikileung's avatar
mikileung
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
    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

     

sonya_m's avatar
sonya_m
SmartBear Alumni (Retired)

Thanks a lot, Marsha!

 

Hi mikileung ! Which approach did you end up using? 

mikileung's avatar
mikileung
Occasional Contributor
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