/// <summary> /// Définition des zones d'impression /// </summary> /// <param name="_sheet"></param> /// <param name="_msgCenter"></param> /// <param name="_scale"></param> private void definePrintSetup(HSSFSheet _sheet, string _msgCenter, short _scale) { HSSFFooter footer = (HSSFFooter)_sheet.Footer; //you can set right, left, and center footers footer.Center = _msgCenter; footer.Right = "Page " + HSSFFooter.Page + " "; HSSFPrintSetup print = (HSSFPrintSetup)_sheet.PrintSetup; print.Landscape = true; //print scale is scale in % – here I’m doing 70% print.Scale = _scale; _sheet.SetMargin(NPOI.SS.UserModel.MarginType.TopMargin, (double).50); //the bottom margin needs to be larger to accommodate my footer text _sheet.SetMargin(NPOI.SS.UserModel.MarginType.BottomMargin, (double)1.00); _sheet.SetMargin(NPOI.SS.UserModel.MarginType.LeftMargin, (double).50); _sheet.SetMargin(NPOI.SS.UserModel.MarginType.RightMargin, (double).50); }