1、样式设置
string strDir = Directory.GetCurrentDirectory();
string fileName = strDir + @"\test.xls";
MSExcel.Application excelApp= new MSExcel.Application();
excelApp.Visible = true;//是打开可见
MSExcel.Workbooks wbks = excelApp.Workbooks;
MSExcel._Workbook wbk = wbks.Add(fileName);
object Nothing = Missing.Value;
MSExcel._Worksheet whs;// = wbk.Sheets.Add(Nothing, Nothing, Nothing, Nothing);
whs = wbk.Sheets[1];//获取第一张工作表
whs.Activate();
((MSExcel.Range)whs.Rows[1, Missing.Value]).Interior.ColorIndex = 3;//设置颜色
((MSExcel.Range)whs.Cells[1, "B"]).Font.Size = 8;//设置字体大小
((MSExcel.Range)whs.Rows[1, Missing.Value]).Font.Bold = true;//设置是否粗体
((MSExcel.Range)whs.Cells[2, 1]).HorizontalAlignment = XlVAlign.xlVAlignCenter;//垂直居中
((MSExcel.Range)whs.Cells[2, 1]).HorizontalAlignment = XlHAlign.xlHAlignCenter;//水平居中