LEADTOOLS Image File Support (Leadtools.Codecs assembly)
LEAD Technologies, Inc

CodecsXlsLoadOptions Class

Example 





Members 
Provides the options for loading Microsoft Excel 97-2003 (XLS) and Microsoft Excel 2007/2010 (XLSX) documents as a raster image. .NET support WinRT support
Object Model
CodecsXlsLoadOptions Class
Syntax
public class CodecsXlsLoadOptions 
'Declaration
 
Public Class CodecsXlsLoadOptions 
'Usage
 
Dim instance As CodecsXlsLoadOptions
public sealed class CodecsXlsLoadOptions 
function Leadtools.Codecs.CodecsXlsLoadOptions()
public ref class CodecsXlsLoadOptions 
Remarks

Microsoft Excel 97-2003 (XLS) and Microsoft Excel 2007/2010 (XLSX) files have no physical width or height in pixels. Use the CodecsRasterizeDocumentOptions to control how the final document is rendered as a raster image. For more information, refer to CodecsRasterizeDocumentLoadOptions.

For more information, refer to File Formats - XLS/XLSX Format.

Important note: The XLS and XLSX file formats support only the following rasterization size modes:

All other size modes will be treated as CodecsRasterizeDocumentSizeMode.Fit.

The XLS/XLSX file formats do not support loading a document using different horizontal or vertical resolutions. So if the value of CodecsRasterizeDocumentLoadOptions.XResolution and CodecsRasterizeDocumentLoadOptions.YResolution are different, the XLS/XLSX codecs will use the larger of the two values as the resolution to use when rasterizing.

Example
 
Public Sub CodecsXlsOptionsExample()
      Dim codecs As New RasterCodecs()

      Dim srcFileName As String = Path.Combine(LEAD_VARS.ImagesDir, "Image1.Xls")

      ' Enable using the RasterizeDocumentOptions
      Dim rasterizeDocumentLoadOptions As CodecsRasterizeDocumentLoadOptions = 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
      codecs.Options.Xls.Load.MultiPageSheet = False

      ' Load the source file
      Using image As RasterImage = codecs.Load(srcFileName)
         ' Show the image information
         Console.WriteLine("Image has {0} pages", image.PageCount)
         Console.WriteLine("Image size: {0} by {1} pixels at {2} by {3} DPI", _
            image.ImageWidth, image.ImageHeight, image.XResolution, image.YResolution)
      End Using

      ' Clean up
      codecs.Dispose()
   End Sub

Public NotInheritable Class LEAD_VARS
   Public Const ImagesDir As String = "C:\Users\Public\Documents\LEADTOOLS Images"
End Class
public void CodecsXlsOptionsExample()
     {
         RasterCodecs codecs = new RasterCodecs();

         string srcFileName = Path.Combine(LEAD_VARS.ImagesDir, "Image1.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
         codecs.Options.Xls.Load.MultiPageSheet = false;

         // Load the source file
         using (RasterImage image = codecs.Load(srcFileName))
         {
             // Show the image information
             Console.WriteLine("Image has {0} pages", image.PageCount);
             Console.WriteLine("Image size: {0} by {1} pixels at {2} by {3} DPI",
                image.ImageWidth, image.ImageHeight, image.XResolution, image.YResolution);
         }

         // Clean up
         codecs.Dispose();
     }

static class LEAD_VARS
{
   public const string ImagesDir = @"C:\Users\Public\Documents\LEADTOOLS Images";
}
CodecsOptionsExamples.prototype.CodecsXlsOptionsExample = function () {
   Tools.SetLicense();
   with (Leadtools) {
      with (Leadtools.Codecs) {
         var codecs = new RasterCodecs();
         var srcFileName = "Assets\\Image1.Xls";

         // Enable using the RasterizeDocumentOptions
         var 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
         codecs.options.xls.load.multiPageSheet = false;

         // Load the source file
         return Tools.AppInstallFolder().getFileAsync(srcFileName).then(function (loadFile) {
            return codecs.loadAsync(LeadStreamFactory.create(loadFile))
         })
         .then(function (image) {

            // Show the image information
            console.info("Image has " + image.pageCount + " pages");
            console.info("Image size: " + image.imageWidth + " by " + image.imageHeight + " pixels at " + image.xresolution + " by " + image.yresolution + " DPI");


            // Clean up
            image.close();
            codecs.close();
         });
      }
   }
}
[TestMethod]
public async Task CodecsXlsOptionsExample()
{
   RasterCodecs codecs = new RasterCodecs();
   string srcFileName = @"Assets\Image1.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
   codecs.Options.Xls.Load.MultiPageSheet = false;

   // Load the source file
   StorageFile loadFile = await Tools.AppInstallFolder.GetFileAsync(srcFileName);
   using (RasterImage image = await codecs.LoadAsync(LeadStreamFactory.Create(loadFile)))
   {
      // 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);
   }

   // Clean up
   codecs.Dispose();
}
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

CodecsXlsLoadOptions Members
Leadtools.Codecs Namespace

 

 


Products | Support | Contact Us | Copyright Notices

© 2006-2012 All Rights Reserved. LEAD Technologies, Inc.