Open-Source .NET API for Excle Files in C# and ASP.NET
Create, open and update contents of an Excel file with FileFormat.Cells for .NET API from within your .NET applications.
What is FileFormat.Cells for .NET API?
FileFormat.Cells for .NET is an open-source user-friendly API for working with Microsoft Excel files from within your .NET application. You can use it to create customized Excel spreadsheets with just few lines of code without putting much efforts. Powered by Microsoft OpenXML SDK, FileFormat.Cells for .NET offers a number of features to meet your spreadsheet requirements. You can utilize this OpenXML SDK wrapper very conveniently in your .NET applications.
FileFormat.Cells for .NET API lets you automate the creation and update of Excel spreadsheets easily. It provides the key functionality of adding sheets, text, open existing spreadsheets in stream, formatting the entire workbook or specific cells, adding images to the spreadsheets, and much more. New features are being added on regular basis to the API for enhanced user experience.
FileFormat.Cells for .NET API - Key Features
Following are some of the main features of FileFormat.Cells for .NET API:
- Comprehensive Spreadsheet Processing: Create, read, edit, and save Excel files in various formats, including XLSX, CSV, and ODS.
- Rich Formatting Options: Apply styles, formatting, and conditional formatting to cells, rows, and columns.
- Formula Support: Calculate formulas dynamically with support for over 500 functions, including custom functions.
- Charting and Graphics: Create and manipulate charts and graphics embedded in spreadsheets.
- Data Import/Export: Import data from and export data to databases, JSON, XML, and other data sources.
- Pivot Tables: Create and manage pivot tables and pivot charts for advanced data analysis.
- Conditional Formatting: Highlight cells dynamically based on specific conditions.
- Support for Macros: Preserve VBA macros in your spreadsheet files.
- Worksheet Protection: Secure worksheets with password protection and permissions.
- High Performance: Handle large spreadsheets efficiently with minimal memory usage.
- Cloud Integration: Work seamlessly with spreadsheets stored on cloud platforms.
- Platform Independence: Fully compatible with .NET Framework, .NET Core, and .NET 5+.
Getting Started with FileFormat.Cells for .NET API
You can download and install the FileFormat.Cells for .NET library from GitHub or Nugget.
Installation
Installing FileFormat.Cells for .NET is simple and can be done from nugget as shown below:
Installing FileFormat.Cells for .NET API
NuGet\Install-Package FileFormat.Cells
Code Examples for FileFormat.Cells for .NET API
FileFormat.Cells for .NET is a powerful spreadsheet processing API that offers rich features for working with Excel XLSX file format. You can use this API in your .NET application for creating an Excel document from scratch, open an existing spreadsheet and updating its contents. It can be easily used in .NET programming languages such as C# and ASP.NET without the need of going into the underlying details of the file foramts.
How to Create an Excel XLSX file file in .NET?
FileFormat.Cells for .NET provides the funcitonality of creating an XLSX file from within your C# or ASP.NET applications. The following code sample demonstrates how to create an Excel XLSX file using FileFormat.Cells for .NET.
How to Insert Text into worksheet Programmatically in C#?
Now that you have created a blank Excel XLSX file with C#, you can use the FileFormat.Cells for .NET to insert text into your spreadsheet. This can be as in the following code sample.
FileFormat.Cells for .NET Resources
Conclusion
FileFormat.Cells for .NET, being an open-source API, lets you take full advantage of working with Excle spreadsheets from within your .NET applications. You can create powerful C# and ASP.NET applications with Excel document processing capabilities. The API is easy to use and provides excellent opportunities for working with spreadsheet files.
