FileFormat.Cells 24.12.0

FileFormat.Cells for .NET

Product Page | Docs | API Reference | Examples | Blog

Open-Source .NET Library For Spreadsheet Automation

FileFormat.Cells is an Open-Source and feature-rich .NET API that simplifies spreadsheet automation. Built on top of OpenXML, this C# library allows developers to easily create, manipulate and manage Excel workbooks. Whether you’re handling reports, data processing, or dynamic worksheet generation, FileFormat.Cells is the go-to solution for developers looking to streamline spreadsheet tasks in .NET.

Key Features

• Spreadsheet Generation: Create professional Excel files from scratch.
• Advanced Worksheet Manipulation: Manage worksheets, rows, and columns with ease.
• Multi-Sheet Management: Add, remove, rename, protect or reorder worksheets..
• Freeze Panes: Easily lock rows and columns to keep key data visible.
• Cell Formatting & Styling: Customize fonts, borders, colors, and more.
• AutoFit Columns: Automatically adjust column widths to match content.
• OpenXML Compatibility: Built on OpenXML for maximum performance and flexibility.

Why FileFormat.Cells?

• Extensible & Lightweight: Designed with extensibility in mind, FileFormat.Cells is ideal for both simple and advanced spreadsheet operations.
• Beginner-Friendly: Whether you’re new to .NET or an experienced developer, this library is straightforward and easy to use.
• Performance-Oriented: Built on OpenXML for fast and efficient handling of large datasets.

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

Installation

• 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

Basic Usage Example

The following code snippet creates an Excel file programmatically and adds text to cell A1:

using FileFormat.Cells;
using System;

class Program
{
    static void Main()
    {
        // Create a new workbook (Excel file)
        using (Workbook workbook = new Workbook())
        {
            // Access the first worksheet in the workbook
            Worksheet sheet = workbook.Worksheets.First();

            // Add text to cell A1
            sheet.Cells["A1"].PutValue("Hello, World!");

            // Save the workbook to the specified file path
            workbook.Save("Z:\\Downloads\\test.xlsx");
        }
    }
}

Coming updates

FileFormat.Cells is planning to add more functionalities to its features bucket. So, stay in touch for regular updates.

License

This project is licensed under the MIT License - see the LICENSE file for details.