C#设置Excel行高、列宽

设置固定值 worksheet.columns[1].columnWidth = 15;

设置自动行高、列宽

 xlApp.columns.AutoFit();
 xlApp.Rows.AutoFit();

其它

•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));  // 单元格背景颜色