FileFormat.Cells is an open-source .NET library developed to automate Spreadsheet creation and management. This is an extensible C# library for Workbook management and modification. Regardless of the user's expertise, this Spreadsheet API is easy to install and use. In addition, the robustness of this API is due to OpenXML which is the core engine of FileFormat.Cells. However, you may install this C# library to achieve Excel file generation and manipulation programmatically. Once this library is set up, you need no third-party library to automate Spreadsheet creation or modification.
| Directory | Description |
|---|---|
| FileFormat.Cells_Tests | This directory contains the unit tests of all the features FileFormat.Cells offers. |
| FileFormat.Cells | It contains all the source code files necessary to execute the features. |
| TestSpreadSheets | This folder includes test files generated by this Open-Souorce .NET API. |
FileFormat.Cells provides seamless Spreadsheet creation and manipulation. Moreover, this Spreadsheet API lets users design Excel files programmatically as per data representation needs.
This Open-Source .NET API comes up with the following functionalities:
- FileFormat.Cells API provides empty Excel file creation as well as with the content. Moreover, .NET developers can open existing Excel files from a file & stream both.
- This .NET Spreadsheet API offers methods and properties to create/delete Worksheets. Further, users can insert/delete data into cells and read rows/columns programmatically.
- There are methods and properties to update the Font family and Font size of the data in Cells.
- Users can leverage the Image namespace to add images to Worksheets. In addition, there are properties and functions to extract images from Worksheets.
Since FileFormat.Cells is available as a NuGet Package, you can download the Nuget Package of this library. Well, the installation procedure of this C# Spreadsheet API is a matter of running a single command as mentioned below:
Install-Package FileFormat.Cells
The following code segment creates an empty Excel file with a default Worksheet.
// Create an object of the Workbook class.
Workbook workbook = new Workbook();
// Call the Save method to save the Excel file onto the disk.
workbook.Save("/spreadsheet.xlsx");
FileFormat.Cells for .NET is planning to add more functionalities to its features bucket. However, after the successful launch of FileFormat.Cells and FileFormat.Words the development of FileFormat.Slides is a work in progress. So, stay in touch for regular updates.