FileFormat.Cells 24.2.0

dotnet add package FileFormat.Cells --version 24.2.0
NuGet\Install-Package FileFormat.Cells -Version 24.2.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="FileFormat.Cells" Version="24.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add FileFormat.Cells --version 24.2.0
#r "nuget: FileFormat.Cells, 24.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install FileFormat.Cells as a Cake Addin
#addin nuget:?package=FileFormat.Cells&version=24.2.0

// Install FileFormat.Cells as a Cake Tool
#tool nuget:?package=FileFormat.Cells&version=24.2.0

FileFormat.Cells for .NET

Version 24.2.0 Nuget

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.

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.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp3.1 is compatible. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on FileFormat.Cells:

Package Downloads
FileFormat.Cells.Examples

Explore a collection of concise C# examples and Gists designed to demonstrate effective techniques for manipulating Excel spreadsheets using the FileFormat.Cells C# API. Streamline your spreadsheet processing tasks with these handy and practical code snippets.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
24.2.0 29 2/22/2024
24.1.0 196 1/17/2024
23.12.0 278 12/18/2023
23.11.0 269 11/16/2023
23.10.0 273 10/17/2023
23.9.0 249 9/25/2023
23.8.0 260 8/22/2023