C# Winform 操作Excel样式

//合并单元格  
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).MergeCells = true;
//水平对齐方式 
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).HorizontalAlignment = XlHAlign.xlHAlignCenter;
//垂直对齐方式 
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).VerticalAlignment = XlVAlign.xlVAlignBottom;
//字体加粗
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).Font.Bold = true;   
//字体颜色
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).Font.ColorIndex = 0;    
//是否斜体 
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).Font.Italic = true; 
//字体大小
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).Font.Size = 22;          
//边框样式
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).Borders.LineStyle = XlLineStyle.xlContinuous;
//行高
xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1, 10]).RowHeight = 33.75;        
//列宽 
xlSheet.get_Range(xlSheet.Cells[2, 1], xlSheet.Cells[2, 1]).ColumnWidth = 33.75;         
//设置单元格内容自动换行
range.WrapText = true;
//自动加行高
worksheet.get_range(worksheet.cells[r+3, 4], worksheet.cells[r+3, 4]).rows.autofit();