Excel 操作进阶

//设置单元格样式：                    wSheet.get_Range(wSheet.Cells[5, i + 3], wSheet.Cells[6, i + 3]).Interior.Color = System.Drawing.ColorTranslator.ToOle(Color.Yellow);  //设置底色                    wSheet.get_Range(wSheet.Cells[5, i + 3], wSheet.Cells[6, i + 3]).Interior.Pattern = Excel.XlPattern.xlPatternLightUp;  //设置斜线样式 //打开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] = "合計:";

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/BachelorLrz/archive/2008/02/28/2128333.aspx