} //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;
}
