private _Workbook _workBook = null;
private Worksheet _workSheet = null;
private Excel.Application _excelApplicatin = null;
 
_excelApplicatin = new Excel.Application();
_workBook = _excelApplicatin.Workbooks.Add(XlSheetType.xlWorksheet);
_workSheet = (Worksheet)_workBook.ActiveSheet;
_workSheet.Name = "workSheetName";
 
 
Excel.Range excelRange = _workSheet.get_Range("A1","I20");

excelRange.Borders.LineStyle = 1;//单元格边框线粗细

excelRange.Font.Size = 15;//设置字体大小

excelRange.Font.Underline = true;  //设置字体是否有下划线

excelRange.HorizontalAlignment = XlHAlign.xlHAlignCenter;//设置字体在单元格内的对其方式

excelRange.ColumnWidth = 15;//设置单元格的宽度

excelRange.Cells.Interior.Color = System.Drawing.Color.FromArgb(255, 204, 153).ToArgb();//设置单元格的背景色

excelRange.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThick,         XlColorIndex.xlColorIndexAutomatic, System.Drawing.Color.Black.ToArgb());// 给单元格加边框

excelRange.EntireColumn.AutoFit();//自动调整列宽

excelRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;// 文本水平居中方式            

excelRange.WrapText = true;//文本自动换行

excelRange.Interior.ColorIndex = 39;//填充颜色为淡紫色

excelRange.Merge(excelRange.MergeCells);//合并单元格

excelRange.NumberFormatLocal = "@";     //设置单元格格式为文本

_workSheet.Cells[1, 1] = "Excel单元格赋值";     //Excel单元格赋值

excelRange.Font.Name="黑体";       设置字体的种类             

excelRange.Font.Color=clBlue;     //字体颜色

_excelApplicatin.DisplayAlerts=false;     //保存Excel的时候，不弹出是否保存的窗口直接进行保存

_worksheet.pageSetup.Zoom = false; //添加后页宽和页高才能显示

_worksheet.pageSetup.FitToPageswide = 1 //调整页高

_worksheet.PageSetup.FitTopagesTall = 1 //调整页宽

_worksheet.PageSetup.Orientation = XlPageOrientation.xlLandscape;//页面打印方向,横向

_worksheet.PageSetup.CenterHorizontally = true; //设置水平居中

_worksheet.PageSetup.PrintArea = "A1:E30"; //打印区域

_worksheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA3;  //打印纸张大小