Provides the options for loading or saving Microsoft Excel (XLSX) and Excel 97-2003 (XLS) documents.
public class CodecsExcelOptions
@interface LTCodecsExcelOptions : NSObject
public class CodecsExcelOptions
public ref class CodecsExcelOptions
class CodecsExcelOptions:
Microsoft Excel (XLSX) and Excel 97-2003 (XLS) documents have no physical width or height in pixels. Use the CodecsRasterizeDocumentOptions to control how to render the final object as a raster image. For more information, refer to CodecsRasterizeDocumentLoadOptions.
Currently, LEADTOOLS does not support saving raster images as XLSX/XLS documents.
For more information, refer to File Formats - XLS/XLSX Format.
using Leadtools;
using Leadtools.Codecs;
using Leadtools.ImageProcessing.Core;
using Leadtools.Pdf;
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
codecs.Dispose();
}
static class LEAD_VARS
{
public const string ImagesDir = @"C:\LEADTOOLS23\Resources\Images";
}
import java.io.File;
import java.io.IOException;
import java.net.URI;
import java.net.URISyntaxException;
import java.nio.file.Paths;
import org.junit.*;
import org.junit.runner.JUnitCore;
import org.junit.runner.Result;
import org.junit.runner.notification.Failure;
import static org.junit.Assert.*;
import leadtools.*;
import leadtools.codecs.*;
import leadtools.imageprocessing.core.MinMaxBitsCommand;
public void codecsExcelOptionsExample() {
final String LEAD_VARS_IMAGES_DIR = "C:\\LEADTOOLS23\\Resources\\Images";
RasterCodecs codecs = new RasterCodecs();
String srcFileName = combine(LEAD_VARS_IMAGES_DIR, "barcode1.tif");
// Enable using the RasterizeDocumentOptions
CodecsRasterizeDocumentLoadOptions rasterizeDocumentLoadOptions = codecs.getOptions().getRasterizeDocument()
.getLoad();
// Fit the document at 8.5 by 11 inches at 96 DPI keeping the aspect ratio
rasterizeDocumentLoadOptions.setSizeMode(CodecsRasterizeDocumentSizeMode.FIT);
rasterizeDocumentLoadOptions.setPageWidth(8.5);
rasterizeDocumentLoadOptions.setPageHeight(11);
rasterizeDocumentLoadOptions.setUnit(CodecsRasterizeDocumentUnit.INCH);
rasterizeDocumentLoadOptions.setXResolution(300);
rasterizeDocumentLoadOptions.setYResolution(300);
// Load each sheet in a separate page - CodecsExcelOptions &
// CodecsExcelLoadOptions reference
codecs.getOptions().getExcel().getLoad().setMultiPageSheet(false);
codecs.getOptions().getExcel().getLoad().setMultiPageEnableMargins(false);
codecs.getOptions().getExcel().getLoad().setMultiPageUseSheetWidth(false);
codecs.getOptions().getExcel().getLoad().setPageOrderDownThenOver(false);
codecs.getOptions().getExcel().getLoad().setShowHiddenSheets(false); // ShowHiddenSheet reference
// Load the source file
RasterImage image = codecs.load(srcFileName);
// Show the image information
System.out.printf("Image has %d pages%n", image.getPageCount());
System.out.printf("Image size: %d by %2d pixels at %3d by %4d DPI",
image.getImageWidth(), image.getImageHeight(), image.getXResolution(), image.getYResolution());
String outputFileName = combine(LEAD_VARS_IMAGES_DIR, "Result.jpg");
codecs.save(image, outputFileName, RasterImageFormat.JPEG, 0);
assertTrue("File unsuccessfully saved to " + outputFileName, (new File(outputFileName)).exists());
System.out.printf("File successfully saved to %s%n", outputFileName);
// To save as BMP, uncomment out this line:
// codecs.save(image, srcFileName + ".bmp", RasterImageFormat.BMP, 24);
// Clean up
image.dispose();
codecs.dispose();
}
Help Collections
Raster .NET | C API | C++ Class Library | HTML5 JavaScript
Document .NET | C API | C++ Class Library | HTML5 JavaScript
Medical .NET | C API | C++ Class Library | HTML5 JavaScript
Medical Web Viewer .NET
Multimedia
Direct Show .NET | C API | Filters
Media Foundation .NET | C API | Transforms
Supported Platforms
.NET, Java, Android, and iOS/macOS Assemblies
Imaging, Medical, and Document
C API/C++ Class Libraries
Imaging, Medical, and Document
HTML5 JavaScript Libraries
Imaging, Medical, and Document
Your email has been sent to support! Someone should be in touch! If your matter is urgent please come back into chat.
Chat Hours:
Monday - Friday, 8:30am to 6pm ET
Thank you for your feedback!
Please fill out the form again to start a new chat.
All agents are currently offline.
Chat Hours:
Monday - Friday
8:30AM - 6PM EST
To contact us please fill out this form and we will contact you via email.