C# Excel几个常用排版例子

全部都是测试可用代码

sheet.Range["A1", "F" + (c + 2)].Borders.LineStyle = 1;  // 边框粗细
            sheet.Range["A1", "F" + (c + 2)].HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; // 对齐方式
            sheet.Range["A1", "F1"].MergeCells = true;  // 合并单元格
            sheet.Range["A1", "F2"].Font.Bold = true;  // 加粗
            sheet.Range["A1", "F1"].Font.Size = 13;  // 字号
            sheet.Range["A1", "F" + (c + 2)].Font.Size = 11;  
            sheet.Range["A1", "F" + (c + 2)].RowHeight = 21;  // 行高
            sheet.Range["A1"].RowHeight = 35;
            sheet.Range["A1", "F1"].ColumnWidth = 17;  // 列宽
            sheet.Range["B1"].ColumnWidth = 20;
            sheet.Range["A2", "F2"].Interior.Color = System.Drawing.ColorTranslator.ToOle(Color.FromArgb(197, 217, 241));  // 单元格背景颜色