使用C#和Excel进行报表开发（六）－操作行和列

在 Excel 中，行和列实际上仍然是 Range ，只不过取得行和列的方法和前面几篇随笔出现的有点不同，要使用 Worksheet 的 Rows 和 Columns 属性的 get_Item 方法，下面是例子代码，演示了怎样选中行，并且在行之间复制数据，和插入行：   ThisApplication = new Excel.Application();   ThisWorkbook = ThisApplication.Workbooks.Open("z://Book1.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);                        ThisApplication.DisplayAlerts = false; xlSheet = (Excel.Worksheet)ThisWorkbook.Worksheets.get_Item(1); //Excel.Range range = xlSheet.get_Range("G4",Type.Missing); Excel.Range range = (Excel.Range)xlSheet.Rows.get_Item(18, Type.Missing); Excel.Range range1 = (Excel.Range)xlSheet.Rows.get_Item(19, Type.Missing); range.Value = "123"; range.Copy(range1); range1.Rows.Insert(XlInsertShiftDirection.xlShiftDown);                                                         ThisWorkbook.SaveAs("z://Book2.xls", Type.Missing, Type.Missing,              Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,              Type.Missing, Type.Missing, Type.Missing, Type.Missing);   关于 Excel 进程的释放，前面几篇随笔已经有了，这里就不再重复了。 <script type="text/javascript">//</script> Feedback