CodecsXlsLoadOptions Class

Summary

Provides the options for loading Microsoft Excel (XLSX) and Excel 97-2003 (XLS) documents as a raster image.

Syntax

C++

Java

public class CodecsXlsLoadOptions

Public Class CodecsXlsLoadOptions

public class CodecsXlsLoadOptions

public ref class CodecsXlsLoadOptions

Remarks

Microsoft Excel (XLSX) and Excel 97-2003 (XLS) 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

This example will load the given Microsoft Excel file (XLSX) and render it as a raster image

using Leadtools; 
using Leadtools.Codecs; 
 
 
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:\LEADTOOLS21\Resources\Images"; 
}

Requirements

Target Platforms

Reference

CodecsXlsLoadOptions Members

Leadtools.Codecs Namespace

Download our FREE evaluation

Help Version 21.0.2021.7.2

Leadtools.Codecs Assembly

Introduction

Getting Started

Namespaces

Leadtools.Codecs Namespace

Assemblies