GemBox.Spreadsheet 43.0.0.1066 UPDATED

How to Use GemBox.Spreadsheet 43.0.0.1066 to Read, Write, and Convert Spreadsheet Files in .NET

GemBox.Spreadsheet is a popular .NET component that allows developers to easily work with spreadsheet files (XLSX, XLS, ODS, CSV, HTML, PDF, or XPS) in their .NET applications. In this article, we will show you how to use the latest version of GemBox.Spreadsheet (43.0.0.1066) to perform some common tasks with spreadsheet files.

Installing GemBox.Spreadsheet 43.0.0.1066

To install GemBox.Spreadsheet 43.0.0.1066, you can use the NuGet Package Manager in Visual Studio or run the following command in the Package Manager Console:

dotnet add package GemBox.Spreadsheet --version 43.0.0.1066

This will add a reference to the GemBox.Spreadsheet.dll assembly in your project.

Reading Spreadsheet Files with GemBox.Spreadsheet 43.0.0.1066

To read a spreadsheet file with GemBox.Spreadsheet 43.0.0.1066, you can use the ExcelFile.Load method and specify the file path and the file format as parameters. For example, to read an Excel file named \"Sample.xlsx\", you can use the following code:

var workbook = ExcelFile.Load(\"Sample.xlsx\", LoadOptions.XlsxDefault);

This will load the workbook object with the data from the file. You can then access the worksheets, cells, ranges, and other objects from the workbook.

Writing Spreadsheet Files with GemBox.Spreadsheet 43.0.0.1066

To write a spreadsheet file with GemBox.Spreadsheet 43.0.0.1066, you can use the ExcelFile.Save method and specify the file path and the file format as parameters. For example, to write an Excel file named \"Output.xlsx\", you can use the following code:

var workbook = new ExcelFile();var worksheet = workbook.Worksheets.Add(\"Sheet1\");worksheet.Cells[0, 0].Value = \"Hello, world!\";workbook.Save(\"Output.xlsx\", SaveOptions.XlsxDefault);

This will create a new workbook object with one worksheet and one cell with some text value and save it to the file.

Converting Spreadsheet Files with GemBox.Spreadsheet 43.0.0.1066

To convert a spreadsheet file from one format to another with GemBox.Spreadsheet 43.0.0.1066, you can use the same ExcelFile.Save method but specify a different file format as a parameter. For example, to convert an Excel file named \"Sample.xlsx\" to a PDF file named \"Sample.pdf\", you can use the following code:

var workbook = ExcelFile.Load(\"Sample.xlsx\", LoadOptions.XlsxDefault);workbook.Save(\"Sample.pdf\", SaveOptions.PdfDefault);

This will load the workbook object from the Excel file and save it as a PDF file.

Conclusion

GemBox.Spreadsheet 43.0.0.1066 is a powerful and easy-to-use .NET component that enables you to read, write, edit, convert, and print spreadsheet files from your .NET applications using one simple API[^1^] [^2^]. You can download a free trial version of GemBox.Spreadsheet 43.0.0.1066 from here and start using it today. aa16f39245