C#控制Excel的打印格式
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;//纸张方向.横向?
