1、全表自动列宽
mysheet.Cells.Select();
mysheet.Cells.Columns.AutoFit();
2、合并
excelRangeParm.Merge(Missing.Value);
3、粗体设置
excelRangeParm.Font.Bold = true;
4、字体大小设置
excelRangeParm.Font.Size = 12;
5、水平对齐设置
excelRangeParm.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
6、垂直对齐设置
excelRangeParm.VerticalAlignment