C#窗体应用实现删除Excel的某行某列

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
string filename = @"  ";
//声明object缺省值
object missing = System.Reflection.Missing.Value;
//实例化excel对象
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
//打开Excel
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Open(filename, missing);
//打开第一个工作表
Microsoft.Office.Interop.Excel.Worksheet worksheet;
worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
//删除第一列
((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[System.Reflection.Missing.Value, 1]
).EntireColumn.Delete(0);
//删除第一行
   ((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[1, System.Reflection.Missing.Value]
).EntireColumn.Delete(0); 
//Cells[Row,Column]  System.Reflection.Missing.Value不指定  不指定行即删除一列，反之则为删除一行