} //public void subMakeExcel(FpSpread oSpread, Chart oChartFx, string sFileTitle, string sHeadL, string sHeadR) private void subPageSetup(int iPrtTitleRow, bool IsPrintTitleRows) { string sPrnDate = "조회일자 : " + DateTime.Now.ToString("yyyy-MM-dd"); if (IsPrintTitleRows == true) { xlSheet.PageSetup.PrintTitleRows = "$1:$" + iPrtTitleRow; } xlSheet.PageSetup.LeftFooter = "&10하나마이크론"; xlSheet.PageSetup.CenterFooter = "&10페이지 : &P/&N"; xlSheet.PageSetup.RightFooter = "&10" + sPrnDate; //xlSheet.PageSetup.LeftMargin = xlApp.InchesToPoints(0.4); //xlSheet.PageSetup.RightMargin = xlApp.InchesToPoints(0.4); //xlSheet.PageSetup.TopMargin = xlApp.InchesToPoints(0.4); //xlSheet.PageSetup.BottomMargin = xlApp.InchesToPoints(0.67); //xlSheet.PageSetup.HeaderMargin = xlApp.InchesToPoints(0.4); //xlSheet.PageSetup.FooterMargin = xlApp.InchesToPoints(0.4); xlSheet.PageSetup.LeftMargin = xlApp.InchesToPoints(0.0); xlSheet.PageSetup.RightMargin = xlApp.InchesToPoints(0.0); xlSheet.PageSetup.TopMargin = xlApp.InchesToPoints(0.0); // 2010-09-07-임종우 : 엑셀 출력 시 하단에 꼬리말이 데이터와 곁쳐 여백 설정함. xlSheet.PageSetup.BottomMargin = xlApp.InchesToPoints(0.5); xlSheet.PageSetup.HeaderMargin = xlApp.InchesToPoints(0.0); xlSheet.PageSetup.FooterMargin = xlApp.InchesToPoints(0.0); xlSheet.PageSetup.CenterHorizontally = true; xlSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape; //페이지 설정 가로 xlSheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA4; //xlPaperA4 xlSheet.PageSetup.Zoom = false; xlSheet.PageSetup.FitToPagesWide = 1; xlSheet.PageSetup.FitToPagesTall = false; }