Excel.Application appExcel=new Excel.Application(); 
Excel.Workbook workbook=appExcel.Application.Workbooks.Add(true); 
appExcel.Visible = true; 
 
//工作薄所在的位置(第一个工作薄) 
Excel.Worksheet xlSheet = (Excel.Worksheet)workbook.Worksheets.get_Item(1); 
 
//上边距 
double top = 0; 
//左边距 
double left = 0; 
//右边距 
double right = 0; 
下边距 
double footer = 0; 
 
xlSheet.DisplayAutomaticPageBreaks = true;//显示分页线    
xlSheet.PageSetup.CenterFooter = "第   &P   页，共   &N   页"; 
xlSheet.PageSetup.TopMargin = appExcel.InchesToPoints(top / 2.54);//上 
xlSheet.PageSetup.BottomMargin = appExcel.InchesToPoints(footer / 2.54);//下 
xlSheet.PageSetup.LeftMargin = appExcel.InchesToPoints(left / 2.54);//左 
xlSheet.PageSetup.RightMargin = appExcel.InchesToPoints(right / 2.54);//右 
xlSheet.PageSetup.CenterHorizontally = true;//水平居中   xlSheet.PageSetup.PrintTitleRows = "$1:$3";//顶端标题行    
xlSheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA3;//A3纸张大小   xlSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;//纸张方向.横向