Vb.net delete excel rows by index -


i'm trying delete rows index using code:

dim xlapp new excel.application dim xlworkbook excel.workbook dim xlworksheet excel.worksheet try     xlworkbook = xlapp.workbooks.open(temprefpath)     xlworksheet = xlworkbook.worksheets("w1")      dim empty integer     empty = + 2 2000         xlworksheet.deleterow     next     xlworkbook.save() catch ex exception     messagebox2(ex.message, me.page)     if not isnothing(xlworkbook)         xlworkbook.close()     end if     xlapp.quit() end try 

but function delete not found.

there no deleterow , if there how know row delete? can without loop, delete rows 5=>10:

xlworksheet.rows(5 & ":" & 10).delete() 

Comments