Ask a Question

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

SOLVED
mikileung
Occasional Contributor

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 in column C. Here is my script. If someone can help, that would be great. 

 

def ExcelExample():

# Get the sheet of the Excel file
excelFile = Excel.Open("C:\\Users\\A\\Desktop\\Test.file\\Temp.xlsx")
excelSheet = excelFile.SheetByTitle["Sheet1"]

# Read data from the Excel file
ColumnNum = 1
RowNum = 2
totalrow = excelSheet.rowCount
NextRow = 2


#Clear column C all content

while RowNum >=2 and RowNum <= totalrow:

valueA = excelSheet.Cell[ColumnNum,RowNum].Value
if valueA==excelSheet.Cell[3,1].Value:

excelSheet.Cell[3,NextRow].Value = excelSheet.Cell[2,RowNum].Value

Log.Message(valueA+excelSheet.Cell[2,RowNum].Value+" added")
RowNum = RowNum+1
NextRow = NextRow +1

else:
RowNum = RowNum+1

else:
excelFile.Save()

11 REPLIES 11
sonya_m
SmartBear Alumni (Retired)

Thanks a lot, Marsha!

 

Hi @mikileung ! Which approach did you end up using? 


Sonya Mihaljova
Community and Education Specialist

mikileung
Occasional Contributor

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

 

cancel
Showing results for 
Search instead for 
Did you mean: