How to delete all rows from excel

[jasmeenkaur27]

Hi

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

[shankar_r]

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