通过程序增删excel行

首先要引用

 Microsoft.Office.Interop.Excel

然后写程序

1、添加行过程

当前工作表   
      ///     
  欲插入的行索引   
      private   void   InsertRows(Excel.Worksheet   sheet,   int   rowIndex)   
      {   
        range   =   (Excel.Range)sheet.Rows[rowIndex,   missing];         
        //object   Range.Insert(object   shift,   object   copyorigin);     
        //shift:   Variant类型，可选。指定单元格的调整方式。可以为下列   XlInsertShiftDirection   常量之一：   
        //xlShiftToRight   或   xlShiftDown。如果省略该参数，Microsoft   Excel   将根据区域形状确定调整方式。   
        range.Insert(Excel.XlInsertShiftDirection.xlShiftDown,   missing);       
      }   

2、删除过程

        //private void RemoveAllsheetData( int delrowcount)//delerowcount删除行数
        //{
        //    Microsoft.Office.Interop.Excel.Application excelApp = null;

        //    Microsoft.Office.Interop.Excel.Workbook book = null;
        //    Microsoft.Office.Interop.Excel.Worksheet sheet = null;
        //    Microsoft.Office.Interop.Excel.Range range = null;
        //    excelApp = new Microsoft.Office.Interop.Excel.Application();
        //    excelApp.Visible = false;
        //    book = excelApp.Workbooks.Open(filename, Missing.Value, false, Missing.Value, Missing.Value, Missing.Value, true, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
        //    sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.Sheets.get_Item("sheet1");
        //    for (int i = 0; i < delrowcount; i++)
        //    {
        //        range = (Microsoft.Office.Interop.Excel.Range)sheet.Rows[1, Missing.Value];
        //        range.EntireRow.Delete(Microsoft.Office.Interop.Excel.XlDeleteShiftDirection.xlShiftUp);
        //    }
        //    sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.Sheets.get_Item("sheet2");
        //    for (int i = 0; i < delrowcount; i++)
        //    {
        //        range = (Microsoft.Office.Interop.Excel.Range)sheet.Rows[1, Missing.Value];
        //        range.EntireRow.Delete(Microsoft.Office.Interop.Excel.XlDeleteShiftDirection.xlShiftUp);
        //    }
        //    book.Save();
        //    book.Close(Missing.Value, Missing.Value, Missing.Value);
        //    excelApp.Workbooks.Close();
        //    excelApp.Quit();
       
        //}

 

3、删除特定的区域

for (int i = 1; i <= 3; i++)
{
  for(j=1;j<=13;j++)
   (Microsoft.Office.Interop.Excel.Worksheet)book.Sheets.get_Item("sheet1").Cells[i,j].Delete();
}