NPOI 1.2.3教程 -8 打印Print

using System;using System.Text;using System.IO;using NPOI.HSSF.UserModel;using NPOI.HPSF;using NPOI.POIFS.FileSystem;using NPOI.SS.UserModel;namespace SetPrintSettingsInXls{ class Program { static void Main(string[] args) { InitializeWorkbook(); Sheet sheet1 = hssfworkbook.CreateSheet("Sheet1"); sheet1.SetMargin(MarginType.RightMargin, (double)0.5); sheet1.SetMargin(MarginType.TopMargin, (double)0.6); sheet1.SetMargin(MarginType.LeftMargin, (double)0.4); sheet1.SetMargin(MarginType.BottomMargin, (double)0.3); sheet1.PrintSetup.Copies = 3; sheet1.PrintSetup.NoColor = true; sheet1.PrintSetup.Landscape = true; sheet1.PrintSetup.PaperSize = (short)PaperSizeType.A4; sheet1.FitToPage = true; sheet1.PrintSetup.FitHeight = 2; sheet1.PrintSetup.FitWidth = 3; sheet1.IsPrintGridlines = true; sheet1.CreateRow(0).CreateCell(0).SetCellValue("This is a Sample"); int x = 1; for (int i = 1; i <= 15; i++) { Row row = sheet1.CreateRow(i); for (int j = 0; j < 15; j++) { row.CreateCell(j).SetCellValue(x++); } } Sheet sheet2 = hssfworkbook.CreateSheet("Sheet2"); sheet2.PrintSetup.Copies = 1; sheet2.PrintSetup.Landscape = false; sheet2.PrintSetup.Notes = true; sheet2.PrintSetup.EndNote = true; sheet2.PrintSetup.CellError = DisplayCellErrorType.ErrorAsNA; sheet2.PrintSetup.PaperSize = (short)PaperSizeType.A5; x = 100; for (int i = 1; i <= 15; i++) { Row row = sheet2.CreateRow(i); for (int j = 0; j < 15; j++) { row.CreateCell(j).SetCellValue(x++); } } WriteToFile(); } static HSSFWorkbook hssfworkbook; static void WriteToFile() { //Write the stream data of workbook to the root directory FileStream file = new FileStream(@"test.xls", FileMode.Create); hssfworkbook.Write(file); file.Close(); } static void InitializeWorkbook() { hssfworkbook = new HSSFWorkbook(); //create a entry of DocumentSummaryInformation DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation(); dsi.Company = "NPOI Team"; hssfworkbook.DocumentSummaryInformation = dsi; //create a entry of SummaryInformation SummaryInformation si = PropertySetFactory.CreateSummaryInformation(); si.Subject = "NPOI SDK Example"; hssfworkbook.SummaryInformation = si; } }}