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.