Forum Discussion
1 Reply
Sort By
- shankar_rCommunity Hero
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
Related Content
- 4 years agoKJ
- 8 months agoEgg
- 2 years agoLennSar
- 2 years agoDesktopapptesti
Recent Discussions
- 6 hours agoSvetaG