Forum Discussion

jasmeenkaur27's avatar
jasmeenkaur27
Contributor
8 years ago

How to delete all rows from excel

Hi

 

I have to delete all rows from excel before executing another function.

  • shankar_r's avatar
    shankar_r
    Community Hero
    8 years ago

    Hi,

     

    You can do like below,

     

    excelObject = Sys.OleObject("Excel.Application");
excelWorkbookObj = excelObject.Workbooks.Open(<strexcelFileName>);
excelMainSheet = excelWorkbookObj.Sheets.Item("<Your sheet name>");
excelMainSheet.UsedRange.ClearContents //this will only clear contents
excelMainSheet.Cells.Clear //this will clear everything