我这个是对EXCEL2000中插入,你试一下:
private void Form1_Load(object sender, System.EventArgs e)
{

 my=new Excel.ApplicationClass();
my.Visible=true;
object objMissing=System.Reflection.Missing.Value;
mybook=my.Workbooks.Open("g:\\123.xls",objMissing,objMissing,objMissing,objMissing,objMissing,objMissing,objMissing,objMissing,objMissing,objMissing,objMissing,objMissing);
mysheet=(Excel.Worksheet)mybook.Worksheets.get_Item(1);

} private void button1_Click(object sender, System.EventArgs e)//添加
{
((Excel.Range) mysheet.Cells[3,3]).Select();
    
((Excel.Range) mysheet.Cells[3,3]).EntireRow.Insert(0); }     
}