用 C# 在EXCEL中插入新的空行和删除空行 急!!! UP有分！！！

[aiyaya]

如题，我该怎么写程序，给个小例子，万分感谢！！！

[aiyaya]

http://community.csdn.net/Expert/topic/3303/3303014.xml?temp=.7733271

已经第三天了，没人会吗？？？ 帮帮忙啊！！！

[心雨楼]

直接插

[tonyye1979]

up

[dazhu2]

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);

}

private void button2_Click(object sender, System.EventArgs e)//DELETE
{
((Excel.Range) mysheet.Cells[3,3]).Select();

((Excel.Range) mysheet.Cells[3,3]).EntireRow.Delete(0);
}

[epp]

UP