Excel中工作薄几种属性的设置(C#)

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;//纸张方向.横向