C#读写Excel文件（二）

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;//水平居中