vb:
xSheet.Range("A3").Resize(1, 3).Insert(Shift:=Excel.XlDirection.xlDown) xSheet.Range("A3").Resize(1, 3).Delete() xSheet.Range("A2").Resize(ds.Tables(i).Rows.Count + 1, 3).Value = data
c#:
((Excel.Range)xSheet.Cells[4, 4]).EntireRow.Insert(null, null); //添加行 ((Excel.Range)xSheet.Cells[4, 4]).EntireRow.Delete(0); ((Excel.Range)xSheet.Cells[3, 1]).get_Resize(count, 11).Value2 = data;