NPOI 打印设置

NPOI 打印设置

   　　　　　　//横向打印
            sheet.PrintSetup.Landscape = true;
            //纸张大小
            sheet.PrintSetup.PaperSize = (int)PaperSize.A4_Small;
            //缩放比：100% 不缩放
            sheet.PrintSetup.Scale = 100;
            //不缩放到一页
            sheet.FitToPage = false;
            //居中对齐
            sheet.HorizontallyCenter = true;
            sheet.VerticallyCenter = true;
            //设置打印边距，数值为打印设置里的边距设置(厘米)/3
            sheet.SetMargin(MarginType.RightMargin, (double)1.6/3);
            sheet.SetMargin(MarginType.TopMargin, (double)0.8/3);
            sheet.SetMargin(MarginType.LeftMargin, (double)1.6 / 3);
            sheet.SetMargin(MarginType.BottomMargin, (double)0.8 / 3);
            //设置打印区域
            workbook.SetPrintArea(1, 0, 5, 0, rowIndex - 1);
            //设置重复出现的行（表头）
            //sheet.RepeatingRows = new NPOI.SS.Util.CellRangeAddress(0, 1, 0, 5);