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
Post a Comment