vb.net - Copy / paste special excel row -
any way speed code
j = 1 clitems.count - 1 = 1 nnumberofrowsperitem xlsheet.rows(nlastitemrow).insert() xlsheet.rows(nfirstitemrow + i).copy() xlsheet.rows(nfirstitemrow + (j * nnumberofrowsperitem) + i).pastespecial() next next j
this function copying 30 empty rows took @ least minute way speed
Comments
Post a Comment