FileFormat.Cells for .NET
Simplify Spreadsheet Creation and Customization with .NET API
Create & customize Spreadsheets easily with FileFormat.Cells, an Open-Source .NET API. Simplify workbook generation & automation with this lightweight library.
What is FileFormat.Cells for .NET?
FileFormat.Cells for .NET offers a simple, easy and user-friendly experience, making it the ideal choice for those looking to work with Microsoft Excel spreadsheets using an open-source API. This open-source .NET API has been thoughtfully designed to simplify the process of creating and customizing Excel spreadsheets. With this intuitive C# library, you can now easily generate and manipulate spreadsheets with just a few lines of code.
The installation process of this lightweight solution is seamless and offers a stack of features to cater to all your Spreadsheet requirements. FileFormat.Cells for .NET leverage the OpenXML SDK, a technology endorsed by Microsoft. FileFormat.Cells for .NET serves as a convenient wrapper that simplifies the utilization of its advanced capabilities.
Designed with developers in mind, this Open-Source .NET library empowers you to easily automate the creation and editing of Excel Spreadsheets with few lines of code. This Open-Source .NET library empowers you to extend its capabilities by leveraging the OpenXML SDK library. FileFormat.Cells for .NET handling FileFormat.Cells for .NET is straight forward, thanks to its user-friendly design. The library boasts a range of intelligent features, including adding sheets, text, opening existing spreadsheets in stream, applying fromatting to entire workbook or specific cell, adding images to the spreadsheets and much more.
Explore our GitHub repository to contribute, suggest improvements, and enhance this Open Source API: https://github.com/fileformat-cells/FileFormat.Cells-for-.NET
At A Glance
An overview of FileFormat.Cells for .NET features.
- Create Workbook
- Open Workbook in Stream
- Insert Sheets into Workbooks
- Apply Formatting to Workbook
- Add Text to Sheet
- Apply Formatting to text
- Add Tables to Sheet
- Add Image to Sheet
FileFormat.Cells for .NET supports popular Microsoft Excel file formats listed below.
- XLSX
- XLSX
Platform Independence
FileFormat.Cells for .NET only requires .NET framework, or .NET Core
Getting Started with FileFormat.Cells for .NET
The recommended way to install FileFormat.Cells for .NET is using NuGet. Please use the following command for a smooth installation.
Install FileFormat.Cells for .NET via NuGet
NuGet\Install-Package FileFormat.Cells Creating an Excel Spreadsheet Programmatically
FileFormat.Cells for .NET makes it easy for software developers to create and manage Excel spreadsheet files inside .NET applications. The following code snippet creates an empty Excel Spreadsheet programmatically.
How to Create an Excel Spreadsheet via .NET API?
// 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");
Insert Text into worksheet Programmatically
The Open Source FileFormat.Cells for .NET library has provided complete functionality for inserting text and images inside Excel spreadsheet files via .NET API. The following code snippet inserts a text into worksheet programmatically.
How to Insert a Text into Worksheet via .NET API?
Workbook workbook = new Workbook();
workbook.ApplyFontStyle("Arial", 14);
Worksheet worksheet = new Worksheet(workbook);
worksheet.insertValue("A10", 10, "some data", 0);
worksheet.saveDataToSheet(0);
workbook.Save("spreadsheet.xlsx");