FileFormat.Cells 24.9.0

FileFormat.Cells for .NET

Open-Source .NET Library For Spreadsheet Automation

FileFormat.Cells is an Open-Source .NET API to streamline the process of generating and overseeing spreadsheets. Designed with extensibility in mind, this C# library excels at managing and refining workbooks. Its user-friendly nature ensures that both novices and experts can swiftly install and harness this Spreadsheet API. The foundation of FileFormat.Cells' robust performance lies in its reliance on OpenXML, the core powerhouse driving its capabilities.

Library Features

FileFormat.Cells not only offers provisions to create new SpreadSheets but also lets developers read & modify the existing spreadsheets programmatically. This .NET library is easy to install and all the processes happen seamlessly.

This Open-Source .NET library offers the following features:

• The FileFormat.Cells API empowers developers with the capability to effortlessly generate Excel files, whether they're empty or pre-filled with content. Furthermore, .NET developers are granted the flexibility to access and manipulate existing Excel files from both file paths and streams.
• This comprehensive .NET Spreadsheet API equips users with a rich assortment of methods and properties for seamless worksheet management. Notably, users can effortlessly create and delete worksheets, while also having the power to insert and delete data within individual cells. Additionally, the API facilitates the programmatic extraction of rows and columns.
• Ensuring a fine-grained control over the presentation of data, the API supplies methods and properties to update the font family and font size within cells.
• Users can leverage the Image namespace to add images to Worksheets. In addition, there are properties and functions to extract images from Worksheets.

Detailed Guides and Examples

For practical, step-by-step guides on using FileFormat.Cells, check out our blog posts:

• How to Open a MS Excel Spreadsheet in C# using FileFormat.Cells
• How to Insert Rows into Excel Worksheets using C# and FileFormat.Cells
• How to Insert Columns into Excel Worksheets using C# and FileFormat.Cells

Let's start

• Given that FileFormat.Cells is conveniently accessible through a NuGet Package, acquiring the library is as straightforward as obtaining the respective NuGet Package. The process of installing this C# Spreadsheet API is effortlessly accomplished through the execution of a single command, outlined below:.

Install-Package FileFormat.Cells

Create an Empty WorkBook Programmatically

The following code snippet creates an empty Excel file programmatically.

// Create an instance of the Document class.
Workbook workbook = new Workbook();

// Invoke the Save method to save the Word document onto the disk.
workbook.Save("/spreadsheet.xlsx");

Open Existing Workbook and add Text to a Cell

The following code snippet opens an Excel file programmatically and add text to a cell.

// Create an instance of the Workbook class.
using (Workbook wb = new Workbook(filePath)) // Open existing workbook
{
    Worksheet firstSheet = wb.Worksheets[0];
    // Put values into cells
    Cell cellA1 = firstSheet.Cells["A1"];
    cellA1.PutValue("Text in A1");
    // Save the workbook
    wb.Save();
}

Coming updates

FileFormat.Cells 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.