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:

  1. Instantiate the SpreadsheetPdfConverter class.
  2. Create a PdfConversionOptions object to configure conversion settings.
  3. Specify the input spreadsheet and output PDF file paths.
  4. Call the Convert method to execute the conversion.

4. How do I convert spreadsheets to HTML?

Using the Spreadsheet to HTML Converter:

  1. Create an instance of the HtmlConverter class.
  2. Configure options (e.g., responsive design settings) via HtmlConversionOptions.
  3. 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:

  1. Instantiate the CsvConverter class and create a CsvConversionOptions object.
  2. Add the input spreadsheet file and specify the output folder.
  3. Set options such as delimiter type.
  4. 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:

  1. Instantiate the SpreadsheetMerger class.
  2. Add the input spreadsheet files and specify an output file via MergeOptions.
  3. Call the Merge method to combine the files.

7. How can I split a large spreadsheet?

Using the Spreadsheet Splitter:

  1. Instantiate the SpreadsheetSplitter class.
  2. Configure split settings with SplitOptions to define how to split the file.
  3. Add the input spreadsheet and specify the output folder.
  4. Call the Split method to create smaller spreadsheet sections.

8. How do I unlock a protected spreadsheet?

To unlock a spreadsheet programmatically:

  1. Create an instance of the SpreadsheetUnlocker class.
  2. Use UnlockOptions to provide password details.
  3. Add the input file and specify an output path.
  4. Call the Unlock method to remove protection.

Specialized Conversion SDKs

11. How can I convert a spreadsheet to JSON?

For converting spreadsheets to JSON:

  1. Instantiate the JsonConverter class.
  2. Use JsonConversionOptions to configure input/output paths and settings.
  3. 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:

  1. Create an instance of the ImageConverter class.
  2. Configure image settings via ImageConversionOptions (e.g., format type, resolution).
  3. 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.

18. How can I convert spreadsheets into other formats like DOC/DOCX?

You can convert spreadsheets to Word documents using the Spreadsheet to Word Converter by:

  1. Creating an instance of the SpreadsheetWordConverter class.
  2. Configuring options with DocConversionOptions.
  3. Adding input/output paths and calling the Convert method.

For more information, visit the official website.

 English