C#实现向excel中插入行列，以及设置单元格合并居中效果

插入空行：

Microsoft.Office.Interop.Excel.Workbook xlsWorkbook;

Microsoft.Office.Interop.Excel.Worksheet xlsSheet = xlsWorkbook.Worksheets[1];

Microsoft.Office.Interop.Excel.Range xlsRow=(Microsoft.Office.Interop.Excel.Range)xlsSheet.Rows[3,MisValue];

xlsRow.Insert(Microsoft.Office.Interop.Excel.xlShiftDown,MisValue);

 

插入空列：

Excel.Range xlsColumns = (Excel.Range)ws.Columns[index, Type.Missing];

            xlsColumns.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, Type.Missing);

            string columnLetter = GetLetter(index - 1);
            ws.Cells[2, index] = txtBoxExpenseType.Text.Trim();
            Excel.Range newExpenseTypeRange = ws.get_Range(string.Format("{0}{1}", columnLetter, 2), string.Format("{0}{1}", columnLetter, 3));
            newExpenseTypeRange.MergeCells