C# 处理Excel的笔记

//打开Excel模板
           Excel.Application excel = new Excel.Application();
           excel.Workbooks.Add(System.Windows.Forms.Application.StartupPath + @"/Report/Template.xls");
           //不使用现有的模板：excel.Workbooks.Add(true);

//向Excel插入一列
            excel.get_Range("J:J", "J:J").Insert(Excel.XlInsertShiftDirection.xlShiftToRight, Excel.XlInsertFormatOrigin.xlFormatFromLeftOrAbove);

//使用公式
            excel.get_Range(excel.Cells[rowIndex, columnIndex], excel.Cells[rowIndex, columnIndex]).FormulaR1C1 = "=RC[-2]*2";

//设置边框线
            Excel.Borders borders = excel.get_Range(excel.Cells[rowIndex, columnIndex], excel.Cells[rowIndex, columnIndex]).Borders;
            borders[Excel.XlBordersIndex.xlEdgeBottom].Weight = Excel.XlBorderWeight.xlThin;
            borders[Excel.XlBordersIndex.xlEdgeLeft].Weight = Excel.XlBorderWeight.xlThin;
            borders[Excel.XlBordersIndex.xlEdgeRight].Weight = Excel.XlBorderWeight.xlThin;
            borders[Excel.XlBordersIndex.xlEdgeTop].Weight = Excel.XlBorderWeight.xlThin;
            borders[Excel.XlBordersIndex.xlInsideHorizontal].Weight = Excel.XlBorderWeight.xlThin;
            borders[Excel.XlBordersIndex.xlInsideVertical].Weight = Excel.XlBorderWeight.xlThin;

//合并单元格
            Excel.Range rangeTotal = excel.get_Range(excel.Cells[rowIndex, columnIndex], excel.Cells[rowIndex, columnIndex+1]);
            rangeTotal.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            rangeTotal.MergeCells = true;
            excel.Cells[rowIndex, 1] = "合計:";