Forum Discussion

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

     

Marsha_R's avatar
Marsha_R
Moderator

What are you trying to accomplish by clearing out that column?  Perhaps we can suggest an easier way to do that.

mikileung's avatar
mikileung
Occasional Contributor
5 years ago

I am generating the temp file from an excel table, based on what data set I need for my other test. is there a simple line of python script that can remove the content in a column (excel)? I have tried a few ones, but it doesn't work. 

  • Marsha_R's avatar
    Marsha_R
    Moderator
    5 years ago

    I would say that best practice is to not destroy data during a test.  How about building the temp table by skipping that column and adding a blank or zero to the temp table at that time?

    • mikileung's avatar
      mikileung
      Occasional Contributor
      5 years ago

      It is not destroying the data, the temp file is generated from the original excel sheet to grab the information I need for each loop for the further test. is there a way that I can clear content in that column before I generate the next batch of data that I need? 

       

      Thanks. 

      • Marsha_R's avatar
        Marsha_R
        Moderator
        5 years ago

        So you are using column A and column B to calculate column C for each loop through the test?  Is that correct?