Subsections of Installation
System Requirements
Sheetize SDKs are designed to integrate seamlessly with .NET applications, supporting a variety of operating systems and development environments. Below are the key system requirements:
Supported Operating Systems
Windows
- Windows 7 (x64, x86)
- Windows 8, 8.1 (x64, x86)
- Windows 10 (x64, x86)
- Windows 11 (x64, x86)
- Windows Server 2003 to Windows Server 2022 (x64, x86)
- Microsoft Azure
macOS
- macOS 10.12 (Sierra) and later
Linux
- Compatible with multiple Linux distributions:
- Ubuntu (16.04, 18.04, 20.04, 22.04)
- CentOS (7, 8)
- Debian (9, 10)
- OpenSUSE (Leap 15+, SLES 12+)
Android
- Supports Android 8.0 (Oreo) and later
Development Environments
- Microsoft Visual Studio:
- Visual Studio 2010 and later (including 2019 and 2022)
- Supports any development environment targeting .NET platforms
Supported .NET Frameworks
- .NET Framework 4.0 and higher
- .NET Standard 2.0 (.NET Core 3.1+)
- .NET 6.0, .NET 7.0, .NET 8.0
Additional Notes
- Adobe Acrobat is not required to use Sheetize SDKs, but is recommended for viewing spreadsheet documents.
Declaration
Sheetize SDKs require a Full Trust permission set when used within .NET applications. This level of permission is necessary to perform critical system-level operations, such as accessing registry settings, system files, and managing fonts.
Why Full Trust is Necessary
The Sheetize SDKs rely on core .NET system classes, which often need elevated permissions for the following reasons:
- Registry Access: Some operations may require reading or writing to the system registry for configuration purposes.
- System Files: Tasks such as handling fonts or file operations may need access to system files beyond the application’s virtual directory.
Limitations in Medium Trust Environments
In hosting environments that enforce Medium Trust security, several critical permissions are restricted or unavailable, which could hinder the functionality of the SDKs. The following limitations apply under Medium Trust:
- OleDbPermission: Prevents the use of ADO.NET managed OLE DB data providers to access databases.
- EventLogPermission: Blocks access to the Windows Event Log, limiting diagnostic capabilities.
- ReflectionPermission: Restricts reflection, affecting certain dynamic operations.
- RegistryPermission: Denies access to the system registry.
- WebPermission: Limits communication to predefined addresses or ranges, as configured in the
<trust>
element. - FileIOPermission: Limits access to files within the application’s virtual directory.
To ensure full functionality, Sheetize SDKs should be used in a Full Trust environment.
Non-Windows Environment
Sheetize SDKs support .NET Standard 2.0, enabling them to be used in .NET Core applications running on Linux or other non-Windows environments. To ensure optimal performance and accurate text rendering, follow the steps below:
Recommended Setup for Linux
1. Install libgdiplus Package
The libgdiplus package provides essential GDI+ functionality, critical for rendering and processing spreadsheets. Install it by running the following command in your terminal:
sudo apt-get install libgdiplus
2. Install Microsoft Compatible Fonts
To ensure correct text rendering, install Microsoft TrueType fonts using:
sudo apt-get install ttf-mscorefonts-installer
These fonts should be located in the /usr/share/fonts/truetype/msttcorefonts
directory. If your system uses a different directory, update the path in your code before performing any operations with Sheetize SDKs:
Sheetize.Text.FontRepository.Sources.Add(new FolderFontSource("<path to ms fonts>"))
Tip
By installing these packages and configuring the font path correctly, you can maximize the performance of Sheetize SDKs on Linux or other non-Windows systems.
Evaluation
You can easily download Sheetize SDKs for evaluation purposes. The evaluation version is fully functional, with the only difference being how you activate the license.
Evaluation Version Limitations
The evaluation version provides full access to all features, but includes the following limitations until a license is applied:
- An evaluation watermark is added to all generated output.
- Only the first four pages of any spreadsheet can be viewed or edited.
To remove these limitations and unlock the full capabilities of Sheetize, simply apply a license by adding a few lines of code to your project.
Subsections of Developer's Guide
HTML Converter
The Sheetize HTML Converter for .NET provides robust capabilities for converting documents between PDF and HTML formats, ideal for web applications, archiving, and report generation. With multiple options for handling resources and layouts, the converter adapts to various project requirements.
Key Features
PDF to HTML Conversion
Convert PDF files to HTML to make documents accessible for web-based viewing or integration into applications where HTML format is preferred.
HTML to PDF Conversion
Transform HTML content into high-quality PDFs, perfect for generating printable reports, archiving web content, or creating shareable document formats.
Detailed Guide
Converting PDF to HTML
To convert a PDF to HTML:
- Initialize the Converter: Create an instance of
HtmlConverter
. - Set Conversion Options: Use
PdfToHtmlOptions
to customize output, choosing either embedded or external resources. - Define Input and Output Paths: Set the paths for your input PDF and output HTML.
- Execute the Conversion: Call the
Process
method to convert the file.
Example: Convert PDF to HTML with Embedded Resources
// Step 1: Initialize the HTML Converter
var converter = new HtmlConverter();
// Step 2: Configure options for PDF to HTML conversion
var options = new PdfToHtmlOptions(PdfToHtmlOptions.SaveDataType.FileWithEmbeddedResources);
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.pdf"));
options.AddOutput(new FileDataSource("output.html"));
// Step 4: Run the conversion
converter.Process(options);
Available Options for PDF to HTML Conversion
SaveDataType:
FileWithEmbeddedResources
: Generates a single HTML file with all resources embedded.FileWithExternalResources
: Saves resources separately, ideal for large HTML files.
Output Customization:
BasePath
: Set the base path for resources in the HTML document.IsRenderToSinglePage
: Optionally render all PDF content on a single HTML page.
Converting HTML to PDF
To convert an HTML document to a PDF, follow these steps:
- Initialize the Converter: Create an instance of the
HtmlConverter
. - Configure PDF Options: Use
HtmlToPdfOptions
to define layout and media settings. - Specify Paths: Set input HTML and output PDF file paths.
- Execute the Conversion: Run the
Process
method to complete the conversion.
Example: Convert HTML to PDF
// Step 1: Initialize the HTML Converter
var converter = new HtmlConverter();
// Step 2: Configure options for HTML to PDF conversion
var options = new HtmlToPdfOptions();
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.html"));
options.AddOutput(new FileDataSource("output.pdf"));
// Step 4: Execute the conversion
converter.Process(options);
Additional Options for HTML to PDF Conversion
Media Type:
HtmlMediaType.Print
: Ideal for generating PDFs suited for printing.HtmlMediaType.Screen
: Use when converting content designed for digital viewing.
Layout Adjustments:
PageLayoutOption
: Adjusts how HTML content fits the PDF layout, like ScaleToPageWidth
to ensure the content scales to the PDF width.IsRenderToSinglePage
: Enables rendering the entire HTML content on a single PDF page if needed for concise presentations.
This converter is versatile for a variety of applications, from generating PDF reports based on web content to converting archives of PDF documents for web-based accessibility. For more advanced configurations, refer to the full Sheetize documentation.
Image Converter
The Sheetize Image Converter for .NET allows developers to convert documents to and from various image formats, making it ideal for applications involving document viewing, image archiving, and generating image-based content.
Key Features
PDF to Image Conversion
Convert PDF documents to image formats (e.g., PNG, JPEG), perfect for generating previews or for image-based document processing.
Image to PDF Conversion
Transform image files into PDF documents, suitable for combining images into a single file or creating PDF reports from image-based data.
Detailed Guide
Converting PDF to Image
To convert a PDF document to an image format:
- Initialize the Converter: Create an instance of
ImageConverter
. - Set Conversion Options: Use
PdfToImageOptions
to specify the desired image format, resolution, and output quality. - Define Input and Output Paths: Set paths for the input PDF and output image files.
- Execute the Conversion: Call the
Process
method to complete the conversion.
Example: Convert PDF to PNG Image
// Step 1: Initialize the Image Converter
var converter = new ImageConverter();
// Step 2: Configure options for PDF to Image conversion
var options = new PdfToImageOptions(ImageType.Png);
options.Resolution = 300; // Set resolution to 300 DPI
options.Quality = 90; // Set image quality to 90%
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.pdf"));
options.AddOutput(new FileDataSource("output.png"));
// Step 4: Run the conversion
converter.Process(options);
Available Options for PDF to Image Conversion
- ImageType: Specify the desired image format (
Png
, Jpeg
, Bmp
, etc.). - Resolution: Set the resolution (DPI) for the output image.
- Quality: Define the quality level (for JPEG output).
Converting Image to PDF
To convert an image to a PDF:
- Initialize the Converter: Create an instance of
ImageConverter
. - Set Conversion Options: Use
ImageToPdfOptions
to customize the layout and appearance of the resulting PDF. - Specify Paths: Set input image and output PDF file paths.
- Execute the Conversion: Call the
Process
method to generate the PDF.
Example: Convert PNG Image to PDF
// Step 1: Initialize the Image Converter
var converter = new ImageConverter();
// Step 2: Configure options for Image to PDF conversion
var options = new ImageToPdfOptions();
options.PageLayoutOption = PageLayoutOption.Centered;
options.ImageScalingOption = ImageScalingOption.FitToPage;
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.png"));
options.AddOutput(new FileDataSource("output.pdf"));
// Step 4: Execute the conversion
converter.Process(options);
Additional Options for Image to PDF Conversion
- PageLayoutOption: Define how the image is placed on the PDF page (e.g.,
Centered
, TopLeft
). - ImageScalingOption: Control how the image fits within the PDF page (e.g.,
FitToPage
, Stretch
).
This converter is versatile for developers needing to work with image-based document content, whether generating high-quality document previews or bundling multiple images into PDFs for easy distribution.
eBook Converter
The Sheetize eBook Converter for .NET enables seamless conversion of documents to and from popular eBook formats such as EPUB and MOBI. It’s ideal for publishers, digital libraries, and developers integrating eBook functionality into their applications.
Key Features
PDF to EPUB Conversion
Easily convert PDF files to EPUB format, optimizing them for eReaders and other devices that support eBook formats.
EPUB to PDF Conversion
Convert eBook content from EPUB to PDF, making it suitable for printing or offline viewing in a standardized format.
Detailed Guide
Converting PDF to EPUB
To convert a PDF document to an EPUB eBook:
- Initialize the Converter: Create an instance of
EbookConverter
. - Set Conversion Options: Use
PdfToEpubOptions
to configure settings for EPUB output, such as image handling and metadata. - Define Input and Output Paths: Set paths for the input PDF and output EPUB.
- Execute the Conversion: Call the
Process
method to convert the document.
Example: Convert PDF to EPUB
// Step 1: Initialize the eBook Converter
var converter = new EbookConverter();
// Step 2: Configure options for PDF to EPUB conversion
var options = new PdfToEpubOptions();
options.IncludeImages = true; // Include images in the output EPUB
options.SetMetadata("Title", "Converted eBook");
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.pdf"));
options.AddOutput(new FileDataSource("output.epub"));
// Step 4: Run the conversion
converter.Process(options);
Available Options for PDF to EPUB Conversion
- IncludeImages: Specify whether to include images from the original PDF in the resulting EPUB.
- SetMetadata: Add metadata such as title, author, and subject to the EPUB file.
Converting EPUB to PDF
To convert an EPUB file to PDF:
- Initialize the Converter: Create an instance of
EbookConverter
. - Configure PDF Options: Use
EpubToPdfOptions
to define settings such as page layout and margins. - Specify Paths: Set the input EPUB and output PDF file paths.
- Execute the Conversion: Call the
Process
method to complete the conversion.
Example: Convert EPUB to PDF
// Step 1: Initialize the eBook Converter
var converter = new EbookConverter();
// Step 2: Configure options for EPUB to PDF conversion
var options = new EpubToPdfOptions();
options.PageLayoutOption = PageLayoutOption.Portrait;
options.Margin = new MarginSettings(10, 10, 10, 10);
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.epub"));
options.AddOutput(new FileDataSource("output.pdf"));
// Step 4: Execute the conversion
converter.Process(options);
Additional Options for EPUB to PDF Conversion
- PageLayoutOption: Set the page layout for the resulting PDF, such as
Portrait
or Landscape
. - MarginSettings: Define margins for the output PDF.
This converter is highly useful for both publishers and developers who need to automate eBook-related workflows. Whether creating eBooks from PDF documents or preparing eBook files for print, the Sheetize eBook Converter provides a flexible solution.
JSON Converter
The Sheetize JSON Converter for .NET offers robust functionality for converting documents to and from JSON format, enabling easy integration into web applications and data processing workflows.
Key Features
Document to JSON Conversion
Convert documents (e.g., PDF, DOCX) to JSON format to extract content in a structured format for further analysis or integration.
JSON to Document Conversion
Transform JSON data into document formats such as PDF or DOCX, allowing for easy report generation or document automation.
Detailed Guide
Converting Document to JSON
To convert a document to JSON:
- Initialize the Converter: Create an instance of
JsonConverter
. - Set Conversion Options: Use
DocumentToJsonOptions
to configure how the document is represented in JSON. - Define Input and Output Paths: Set paths for the input document and output JSON file.
- Execute the Conversion: Call the
Process
method to convert the document.
Example: Convert PDF to JSON
// Step 1: Initialize the JSON Converter
var converter = new JsonConverter();
// Step 2: Configure options for Document to JSON conversion
var options = new DocumentToJsonOptions();
options.IncludeMetadata = true; // Include metadata in the JSON output
options.FormatOutput = true; // Format the JSON output for readability
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.pdf"));
options.AddOutput(new FileDataSource("output.json"));
// Step 4: Run the conversion
converter.Process(options);
Available Options for Document to JSON Conversion
- IncludeMetadata: Specify whether to include document metadata in the JSON output.
- FormatOutput: Choose whether to format the JSON for readability.
Converting JSON to Document
To convert JSON data to a document:
- Initialize the Converter: Create an instance of
JsonConverter
. - Set Conversion Options: Use
JsonToDocumentOptions
to define the target document format and layout. - Specify Paths: Set input JSON and output document file paths.
- Execute the Conversion: Call the
Process
method to generate the document.
Example: Convert JSON to PDF
// Step 1: Initialize the JSON Converter
var converter = new JsonConverter();
// Step 2: Configure options for JSON to Document conversion
var options = new JsonToDocumentOptions(DocumentFormat.Pdf);
options.PageLayoutOption = PageLayoutOption.Portrait;
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.json"));
options.AddOutput(new FileDataSource("output.pdf"));
// Step 4: Execute the conversion
converter.Process(options);
Additional Options for JSON to Document Conversion
- DocumentFormat: Specify the target format (
Pdf
, Docx
, etc.). - PageLayoutOption: Define the page layout for the resulting document (
Portrait
, Landscape
).
This converter provides powerful capabilities for integrating document content with web services and other data-driven applications. Whether extracting data from documents or generating documents from structured data, the Sheetize JSON Converter is an ideal solution for modern document workflows.
PDF Converter
The Sheetize PDF Converter for .NET offers advanced functionality for converting documents to and from PDF format, making it ideal for archiving, sharing, and ensuring consistent document formatting across different devices.
Key Features
Convert documents from multiple formats, such as DOCX, HTML, and images, to PDF for easy distribution and printability.
Convert PDF documents into other formats, such as DOCX, HTML, and images, for easy editing or integration into other workflows.
Detailed Guide
Converting Documents to PDF
To convert a document to PDF:
- Initialize the Converter: Create an instance of
PdfConverter
. - Set Conversion Options: Use
DocumentToPdfOptions
to configure settings such as page layout and compression. - Define Input and Output Paths: Set the paths for the input document and output PDF.
- Execute the Conversion: Call the
Process
method to convert the document.
Example: Convert DOCX to PDF
// Step 1: Initialize the PDF Converter
var converter = new PdfConverter();
// Step 2: Configure options for document to PDF conversion
var options = new DocumentToPdfOptions();
options.PageLayoutOption = PageLayoutOption.Portrait;
options.CompressionLevel = CompressionLevel.High;
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.docx"));
options.AddOutput(new FileDataSource("output.pdf"));
// Step 4: Run the conversion
converter.Process(options);
Available Options for Document to PDF Conversion
- PageLayoutOption: Define the page layout for the resulting PDF (
Portrait
, Landscape
). - CompressionLevel: Specify the compression level for reducing file size (
Low
, Medium
, High
).
To convert a PDF document into another format:
- Initialize the Converter: Create an instance of
PdfConverter
. - Configure Conversion Options: Use
PdfToDocumentOptions
to specify the output format and any customization. - Specify Paths: Set the input PDF and output document file paths.
- Execute the Conversion: Call the
Process
method to complete the conversion.
Example: Convert PDF to DOCX
// Step 1: Initialize the PDF Converter
var converter = new PdfConverter();
// Step 2: Configure options for PDF to DOCX conversion
var options = new PdfToDocumentOptions(DocumentFormat.Docx);
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.pdf"));
options.AddOutput(new FileDataSource("output.docx"));
// Step 4: Execute the conversion
converter.Process(options);
- DocumentFormat: Specify the desired output format (
Docx
, Html
, Png
, etc.). - TextExtractionMode: Define how text is extracted from the PDF (
PlainText
, FormattedText
).
The Sheetize PDF Converter is an essential tool for managing documents, whether you need to create universally shareable PDF files or convert PDFs back to editable formats. It provides flexibility in both directions, making it a powerful addition to any developer’s toolkit.
Spreadsheet Converter
The Sheetize Spreadsheet Converter for .NET provides functionality to convert spreadsheets between different formats, making it suitable for data transformation, reporting, and integration tasks.
Key Features
Convert Spreadsheet to PDF
Convert spreadsheet files (e.g., XLSX, CSV) to PDF for easy sharing and printing.
Convert spreadsheets to formats such as CSV, JSON, or HTML, enabling integration with web applications or data processing workflows.
Detailed Guide
Converting Spreadsheet to PDF
To convert a spreadsheet to PDF:
- Initialize the Converter: Create an instance of
SpreadsheetConverter
. - Set Conversion Options: Use
SpreadsheetToPdfOptions
to configure settings such as page layout, fit options, and watermarking. - Define Input and Output Paths: Set paths for the input spreadsheet and output PDF.
- Execute the Conversion: Call the
Process
method to complete the conversion.
Example: Convert XLSX to PDF
// Step 1: Initialize the Spreadsheet Converter
var converter = new SpreadsheetConverter();
// Step 2: Configure options for spreadsheet to PDF conversion
var options = new SpreadsheetToPdfOptions();
options.PageLayoutOption = PageLayoutOption.Landscape;
options.FitToPage = true; // Ensure the spreadsheet fits to a single page
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.xlsx"));
options.AddOutput(new FileDataSource("output.pdf"));
// Step 4: Run the conversion
converter.Process(options);
Available Options for Spreadsheet to PDF Conversion
- PageLayoutOption: Define the page orientation for the resulting PDF (
Portrait
, Landscape
). - FitToPage: Specify whether to fit the spreadsheet content onto a single page.
To convert a spreadsheet into another format (e.g., CSV, HTML):
- Initialize the Converter: Create an instance of
SpreadsheetConverter
. - Configure Conversion Options: Use
SpreadsheetToDocumentOptions
to specify the target format. - Specify Paths: Set input spreadsheet and output file paths.
- Execute the Conversion: Call the
Process
method to generate the output.
Example: Convert XLSX to CSV
// Step 1: Initialize the Spreadsheet Converter
var converter = new SpreadsheetConverter();
// Step 2: Configure options for spreadsheet to CSV conversion
var options = new SpreadsheetToDocumentOptions(DocumentFormat.Csv);
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.xlsx"));
options.AddOutput(new FileDataSource("output.csv"));
// Step 4: Execute the conversion
converter.Process(options);
Additional Options for Spreadsheet to Document Conversion
- DocumentFormat: Define the desired output format (
Csv
, Json
, Html
). - IncludeFormulas: Choose whether to include calculated formulas or only static values in the output.
The Sheetize Spreadsheet Converter is highly versatile, providing support for transforming spreadsheets into various formats to accommodate different needs. Whether you are creating PDF reports from spreadsheets or extracting data for processing, this converter offers a reliable solution for developers.
Spreadsheet Merger
The Sheetize Spreadsheet Merger for .NET allows developers to merge multiple spreadsheet files into one, ideal for consolidating data from different sources into a unified report.
Key Features
Merge Multiple Spreadsheets
Combine multiple spreadsheets into a single file, preserving data integrity and formatting.
Detailed Guide
Merging Spreadsheets
To merge multiple spreadsheets into one:
- Initialize the Merger: Create an instance of
SpreadsheetMerger
. - Add Input Files: Add all the spreadsheets to be merged.
- Specify Output Path: Set the output file path for the merged spreadsheet.
- Execute the Merge: Call the
Process
method to merge the files.
Example: Merge Multiple XLSX Files
// Step 1: Initialize the Spreadsheet Merger
var merger = new SpreadsheetMerger();
// Step 2: Add input files
merger.AddInput(new FileDataSource("input1.xlsx"));
merger.AddInput(new FileDataSource("input2.xlsx"));
// Step 3: Set the output file path
merger.AddOutput(new FileDataSource("merged_output.xlsx"));
// Step 4: Run the merge process
merger.Process();
This functionality is especially useful for creating unified reports or consolidating data from multiple sources without manual intervention.
Spreadsheet Splitter
The Sheetize Spreadsheet Splitter for .NET helps developers split large spreadsheet files into smaller parts, ideal for data distribution and management.
Key Features
Split Spreadsheets into Smaller Files
Split large spreadsheet files by sheet, range, or custom rules for easier handling and sharing.
Detailed Guide
Splitting a Spreadsheet
To split a spreadsheet into multiple smaller files:
- Initialize the Splitter: Create an instance of
SpreadsheetSplitter
. - Set Splitting Criteria: Use
SplitterOptions
to specify how to split (e.g., by sheet or by row count). - Define Input and Output Paths: Set the input file and the paths for the output split files.
- Execute the Split: Call the
Process
method to split the file.
Example: Split XLSX by Sheet
// Step 1: Initialize the Spreadsheet Splitter
var splitter = new SpreadsheetSplitter();
// Step 2: Configure options for splitting by sheet
var options = new SplitterOptions(SplitMode.BySheet);
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.xlsx"));
options.AddOutput(new FileDataSource("output_directory"));
// Step 4: Execute the split process
splitter.Process(options);
This tool is perfect for dividing large files into smaller, manageable pieces, making data more accessible and easier to work with.
Spreadsheet Unlocker
The Sheetize Spreadsheet Unlocker for .NET provides the capability to remove protection from spreadsheets, allowing developers to edit or reformat locked content.
Key Features
Unlock Protected Spreadsheets
Remove password protection or sheet-level locking to enable modifications to the spreadsheet.
Detailed Guide
Unlocking a Protected Spreadsheet
To unlock a protected spreadsheet:
- Initialize the Unlocker: Create an instance of
SpreadsheetUnlocker
. - Provide Unlocking Credentials: Set the password or specify other unlocking parameters.
- Define Input and Output Paths: Set the paths for the input locked file and the output unlocked file.
- Execute the Unlocking: Call the
Process
method to unlock the file.
Example: Unlock an XLSX File
// Step 1: Initialize the Spreadsheet Unlocker
var unlocker = new SpreadsheetUnlocker();
// Step 2: Set unlocking credentials
var options = new UnlockerLoadOptions();
options.Password = "password123";
// Step 3: Set file paths
options.AddInput(new FileDataSource("locked_input.xlsx"));
options.AddOutput(new FileDataSource("unlocked_output.xlsx"));
// Step 4: Run the unlocking process
unlocker.Process(options);
The Spreadsheet Unlocker is useful for developers needing to programmatically modify protected spreadsheets.
Text Converter
The Sheetize Text Converter for .NET enables the conversion of documents to and from plain text format, ideal for data extraction, archiving, and integration with text-based systems.
Key Features
Convert Documents to Plain Text
Extract text content from documents like PDF, DOCX, and HTML, useful for data processing and archiving.
Convert Plain Text to Document Formats
Create formatted documents from plain text, providing an easy way to generate reports or structured files.
Detailed Guide
Converting Document to Plain Text
To convert a document to plain text:
- Initialize the Converter: Create an instance of
TextConverter
. - Set Conversion Options: Use
DocumentToTextOptions
to configure output settings. - Define Input and Output Paths: Set paths for the input document and output text file.
- Execute the Conversion: Call the
Process
method to convert the document.
Example: Convert PDF to Plain Text
// Step 1: Initialize the Text Converter
var converter = new TextConverter();
// Step 2: Configure options for document to text conversion
var options = new DocumentToTextOptions();
// Step 3: Set file paths
options.AddInput(new FileDataSource("input.pdf"));
options.AddOutput(new FileDataSource("output.txt"));
// Step 4: Execute the conversion
converter.Process(options);
The Text Converter is essential for scenarios where text extraction is needed, such as creating archives or processing data in plain text.
FAQs
This FAQ provides in-depth information about the features and functionalities of Sheetize .NET SDKs, covering aspects like spreadsheet conversion, document management, and compatibility details.
General Questions
1. What is Sheetize for .NET?
Sheetize for .NET is a powerful SDK designed for managing spreadsheet documents programmatically. It includes tools for converting spreadsheets to various formats, editing cell data, handling spreadsheet forms, and optimizing document workflows.
2. How do I install Sheetize SDKs for .NET?
You can install the Sheetize SDKs by downloading assembly files from the official website or by fetching packages directly from NuGet. Detailed installation instructions are provided in each SDK’s documentation.
Spreadsheet Conversion
3. How can I convert a spreadsheet to PDF?
To convert a spreadsheet to PDF format using the Spreadsheet to PDF Converter:
- Instantiate the
SpreadsheetPdfConverter
class. - Create a
PdfConversionOptions
object to configure conversion settings. - Specify the input spreadsheet and output PDF file paths.
- Call the
Convert
method to execute the conversion.
4. How do I convert spreadsheets to HTML?
Using the Spreadsheet to HTML Converter:
- Create an instance of the
HtmlConverter
class. - Configure options (e.g., responsive design settings) via
HtmlConversionOptions
. - Specify input/output file paths and call the
Convert
method.
5. How do I convert a spreadsheet to CSV?
To convert a spreadsheet to CSV:
- Instantiate the
CsvConverter
class and create a CsvConversionOptions
object. - Add the input spreadsheet file and specify the output folder.
- Set options such as delimiter type.
- Call the
Convert
method to generate the CSV file.
Document Management
6. How do I merge multiple spreadsheets into one?
To merge spreadsheets using the Spreadsheet Merger:
- Instantiate the
SpreadsheetMerger
class. - Add the input spreadsheet files and specify an output file via
MergeOptions
. - Call the
Merge
method to combine the files.
7. How can I split a large spreadsheet?
Using the Spreadsheet Splitter:
- Instantiate the
SpreadsheetSplitter
class. - Configure split settings with
SplitOptions
to define how to split the file. - Add the input spreadsheet and specify the output folder.
- Call the
Split
method to create smaller spreadsheet sections.
8. How do I unlock a protected spreadsheet?
To unlock a spreadsheet programmatically:
- Create an instance of the
SpreadsheetUnlocker
class. - Use
UnlockOptions
to provide password details. - Add the input file and specify an output path.
- Call the
Unlock
method to remove protection.
Specialized Conversion SDKs
11. How can I convert a spreadsheet to JSON?
For converting spreadsheets to JSON:
- Instantiate the
JsonConverter
class. - Use
JsonConversionOptions
to configure input/output paths and settings. - Call the
Convert
method to produce the JSON file.
12. How do I convert a spreadsheet to images (e.g., JPEG, PNG)?
Using the Spreadsheet to Image Converter:
- Create an instance of the
ImageConverter
class. - Configure image settings via
ImageConversionOptions
(e.g., format type, resolution). - Add input/output file paths and call the
Convert
method.
Licensing and Compatibility
13. What are the system requirements for using Sheetize SDKs?
Sheetize supports:
- Operating Systems: Windows 7-11, Windows Server 2008-2022, macOS (10.14+), and Linux.
- Frameworks: .NET Framework 4.0 to 8.0.
- IDE: Compatible with various versions of Visual Studio.
14. How do I set license keys for Sheetize SDKs?
To activate an SDK, reference Sheetize in your project and set the license keys before using any methods. Detailed instructions are provided in each SDK’s documentation.
15. Where can I find more examples and documentation for Sheetize?
Complete API documentation and examples are available on the Sheetize website, or through the NuGet packages within your development environment.
Additional Features
17. Is Sheetize limited to working with spreadsheets only?
While Sheetize primarily focuses on spreadsheet manipulation, it also supports conversions to and from formats like JSON, HTML, PDF, and image formats such as JPEG and PNG.
You can convert spreadsheets to Word documents using the Spreadsheet to Word Converter by:
- Creating an instance of the
SpreadsheetWordConverter
class. - Configuring options with
DocConversionOptions
. - Adding input/output paths and calling the
Convert
method.
For more information, visit the official website.