←Select platform

MultiPageSheet Property


Gets or sets a value indicating whether to use multiple pages for each sheet.


public bool MultiPageSheet {get; set;} 
@property (nonatomic, assign) BOOL multiPageSheet; 
public boolean isMultiPageSheet() 
public void setMultiPageSheet(boolean multiPageSheet) 
property bool MultiPageSheet { 
   bool get(); 
   void set (    bool ); 
MultiPageSheet # get and set (CodecsExcelLoadOptions) 

Property Value

Value Description
true To draw each sheet on multiple pages, when the final sheet size is greater than the page size.
false To always draw each sheet on one page. The default value is false.


Depending on the current rasterization options set with CodecsRasterizeDocumentLoadOptions, the resulting physical render size of the page may be smaller than the full sheet. If the value of MultiPageSheet is set to true, then each sheet will use as many pages as it needs. Otherwise, exactly one page per sheet will be used.

Notice that if the sheet size is larger than the page size specified by the user, and this property is set to false, the sheet will be fitted according to the CodecsRasterizeDocumentLoadOptions.SizeMode property.

MultiPageUseSheetWidth and PageOrderDownThenOver can be used when the value of MultiPageSheet is true.


using Leadtools; 
using Leadtools.Codecs; 
using Leadtools.ImageProcessing.Core; 
public void CodecsExcelOptionsExample() 
   RasterCodecs codecs = new RasterCodecs(); 
   string srcFileName = Path.Combine(LEAD_VARS.ImagesDir, "test.Xls"); 
   // Enable using the RasterizeDocumentOptions 
   CodecsRasterizeDocumentLoadOptions rasterizeDocumentLoadOptions = codecs.Options.RasterizeDocument.Load; 
   // Fit the document at 8.5 by 11 inches at 96 DPI keeping the aspect ratio 
   rasterizeDocumentLoadOptions.SizeMode = CodecsRasterizeDocumentSizeMode.Fit; 
   rasterizeDocumentLoadOptions.PageWidth = 8.5; 
   rasterizeDocumentLoadOptions.PageHeight = 11; 
   rasterizeDocumentLoadOptions.Unit = CodecsRasterizeDocumentUnit.Inch; 
   rasterizeDocumentLoadOptions.XResolution = 300; 
   rasterizeDocumentLoadOptions.YResolution = 300; 
   // Load each sheet in a separate page - CodecsExcelOptions & CodecsExcelLoadOptions reference 
   codecs.Options.Excel.Load.MultiPageSheet = false; 
   codecs.Options.Excel.Load.MultiPageEnableMargins = false; 
   codecs.Options.Excel.Load.MultiPageUseSheetWidth = false; 
   codecs.Options.Excel.Load.PageOrderDownThenOver = false; 
   codecs.Options.Excel.Load.ShowHiddenSheets = false; // ShowHiddenSheet reference 
   // Load the source file 
   using (RasterImage image = codecs.Load(srcFileName)) 
      // Show the image information 
      Debug.WriteLine("Image has {0} pages", image.PageCount); 
      Debug.WriteLine("Image size: {0} by {1} pixels at {2} by {3} DPI", 
         image.ImageWidth, image.ImageHeight, image.XResolution, image.YResolution); 
      //To save as BMP, uncomment out this line: 
      //codecs.Save(image, srcFileName + ".bmp", RasterImageFormat.Bmp, 24); 
   // Clean up 
static class LEAD_VARS 
   public const string ImagesDir = @"C:\LEADTOOLS22\Resources\Images"; 


Target Platforms

See Also

CodecsExcelLoadOptions Class

CodecsExcelLoadOptions.MultiPageUseSheetWidth property

CodecsExcelLoadOptions.PageOrderDownThenOver property

CodecsExcelLoadOptions Members

Help Version 22.0.2023.5.5
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Codecs Assembly

Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.