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