Skip to footer content
  1. IronXL
  2. IronXL Blog
  3. Using IronXL
  4. C# Spreadsheet
USING IRONXL

How to Edit a Spreadsheet in C#

Jordi Bardia
Jordi Bardia
Updated:

Edit Excel spreadsheets in C# using IronXL library without Microsoft Office by loading workbooks, manipulating cell values with formulas, and saving files—all through simple code-based operations.

This article will explore spreadsheet manipulation in C#, using the IronXL library named IronXL without interacting with the user interface. Whether you're working with Excel files in ASP.NET applications or building desktop solutions, IronXL provides a comprehensive approach to reading Excel files and manipulating spreadsheet data programmatically.

How Do I Edit a Spreadsheet in C#?

The ability to edit and manipulate Excel file data using C# can be extremely helpful to businesses and developers. Here's how to do this in five simple steps:

  1. Install the C# library for editing spreadsheets.
  2. Use WorkBook.Load to open an Excel file.
  3. Set cell values using Worksheet.Value method.
  4. Apply Range.Sum to calculate cell totals.
  5. Save the file using SaveAs method.

For developers looking to perform more advanced operations, IronXL also supports creating Excel charts programmatically, applying conditional formatting, and working with formulas.

What Is IronXL and Why Should I Use It?

IronXL is a comprehensive library designed specifically for C# spreadsheet processing. It enables developers to work with Excel in C# without Interop, making it ideal for server environments and cloud deployments.

Whether you're working on a financial application, data-driven dashboard, or any project involving tabular data, IronXL provides a robust solution that simplifies complex spreadsheet operations in C# development. You can easily implement it in your web applications or .NET applications. The library supports deployment to AWS, Azure environments, and even Docker containers.

This article will explore the key features and benefits of IronXL, showing how it enhances the efficiency and functionality of C# applications that deal with Excel spreadsheet processing. Using IronXL, you can manipulate Excel spreadsheets without needing Microsoft Office applications, and you can create advanced Excel spreadsheets without Microsoft Excel and Excel Interop. The library also works seamlessly on Linux and macOS platforms, making it truly cross-platform.

How Do I Create a New Visual Studio Project for Excel Manipulation?

Before installing IronXL, it's necessary to create a new Visual Studio C# project or load an existing one. Here are the steps to create a new project in Visual Studio. If you're working with different frameworks, IronXL also supports .NET MAUI, Blazor, and VB.NET.

What Are the Initial Steps to Set Up Visual Studio?

  1. Open Visual Studio and click the File menu. A drop-down menu will appear. Click New in the dropdown menu, and another side menu will appear. Click Project.

    Visual Studio File menu expanded showing options to create a new project, open repositories, and manage files Navigate to creating a new project in Visual Studio

  2. A new window will appear. Click the search bar and type Console Application. Select the one with the C# option. Then click the Next button.

    Visual Studio's 'Create a new project' dialog showing Console Application templates for C#, with the first option highlighted for creating a .NET Core console app that runs on Windows, Linux, and macOS Create a new project dialog in Visual Studio

How Do I Configure My Project Settings?

  1. A new configuration window will open. Write the project name, set the project location, and then click the Next button.

    Visual Studio new project configuration dialog showing settings for a Console Application named 'SpreadSheet' targeting Windows, Linux, macOS, and Console platforms Configure the new project

  2. The last window will appear. Select the target framework and click the Create button.

    Visual Studio project creation dialog showing the Additional Information page with .NET 5.0 target framework selected for a Console Application Target Framework selection

How Do I Install the IronXL Spreadsheet Library?

Once the project is created, let's install the free IronXL C# library. Here are the steps to install IronXL in your C# project. You'll need to apply a license key for production use, but the library offers a trial license for evaluation purposes.

What Is the Best Way to Install IronXL via NuGet?

  1. In Visual Studio, go to Tools. A drop-down menu will appear. Click NuGet Package Manager in the dropdown menu, and a side menu will appear. Click Manage NuGet Packages for Solution.

    Visual Studio Tools menu open showing the NuGet Package Manager option under the Tools menu Navigate to NuGet Package Manager

  2. A new window will appear. Go to the Browse tab and in the search bar, type IronXL. A list of IronXL packages will appear. Select the latest package and click install.

    NuGet Package Manager window showing IronXL.Excel package selected with version 2023.11.12 ready to install Install the IronXL package in the NuGet Package Manager

How Can I Edit Excel Files and Spreadsheets Using IronXL?

IronXL offers many spreadsheet manipulation features that allow you to change cell values, font size, background color of columns, cell ranges, and much more. The library supports various operations including adding rows and columns, merging cells, setting cell borders and alignment, and applying background patterns and colors.

This section will demonstrate how to load a dataset from a spreadsheet Excel file, edit it, then format and manipulate the data. For more advanced operations, you can also add comments to cells, set hyperlinks, and freeze panes for better navigation in large spreadsheets.

How Do I Change Spreadsheet Entries Using C#?

Here's a code example that changes Excel entries using C# with just a few lines of code. This approach is similar to editing Excel files programmatically, but focuses on basic cell value manipulation.

Input Excel File

Excel spreadsheet showing a simple inventory table with Items, Quantity, Price, and Total columns containing data for AXE, Pen, Shoes, and Socks The input Excel file

using IronXL;

// Load an existing Excel file
WorkBook workBook = WorkBook.Load("test.xlsx");

// Get the default worksheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set the value of cell A1
workSheet["A1"].Value = "Hello World Created by IronXL";

// Save the modified workbook as a new file
workBook.SaveAs("sample.xlsx");
using IronXL;

// Load an existing Excel file
WorkBook workBook = WorkBook.Load("test.xlsx");

// Get the default worksheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set the value of cell A1
workSheet["A1"].Value = "Hello World Created by IronXL";

// Save the modified workbook as a new file
workBook.SaveAs("sample.xlsx");
$vbLabelText   $csharpLabel

The provided code uses the IronXL library in C# to manipulate spreadsheets in Excel files. It begins by importing the IronXL namespace. Then, it loads an existing Excel file named "test.xlsx" into a WorkBook object using the load spreadsheet functionality.

The default worksheet of this workbook is accessed and assigned to a WorkSheet variable. The code sets the value of cell A1 in the worksheet to "Hello World Created by IronXL". Finally, the modified spreadsheet is saved as an XLSX file, "sample.xlsx", using the SaveAs method. For more complex scenarios, you can also convert between different spreadsheet file types or export to formats like CSV, JSON, or XML.

Output File

Excel spreadsheet showing a simple inventory table with columns for item names, quantity, price, and calculated totals for products like AXE, Pen, Shoes, and Socks The output file

How Can I Add Formulas to Calculate Cell Values?

IronXL offers a free version of this feature where you can use formulas on spreadsheets and write them to other cells. Here's an example using the C# IronXL Spreadsheet Library. For more complex calculations, you can explore math functions and Excel formulas in C#.

using IronXL;

// Load the existing Excel file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the default worksheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Select a range of cells from D2 to D5
var range = workSheet["D2:D5"];

// Calculate the sum of the values in the range
decimal sum = range.Sum();

// Set the sum in cell D6 and label in C6
workSheet["D6"].Value = sum;
workSheet["C6"].Value = "Total Price:";

// Save the modified workbook
workBook.SaveAs("sample.xlsx");
using IronXL;

// Load the existing Excel file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the default worksheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Select a range of cells from D2 to D5
var range = workSheet["D2:D5"];

// Calculate the sum of the values in the range
decimal sum = range.Sum();

// Set the sum in cell D6 and label in C6
workSheet["D6"].Value = sum;
workSheet["C6"].Value = "Total Price:";

// Save the modified workbook
workBook.SaveAs("sample.xlsx");
$vbLabelText   $csharpLabel

This code uses the IronXL library in C# to manipulate an Excel file named "sample.xlsx." It begins by loading the existing Excel file into a WorkBook object. For more information on working with ranges, see our guide on selecting ranges.

The default worksheet of this workbook is accessed and assigned to a WorkSheet variable. Subsequently, a specific range of cells, from D2 to D5, is selected using the workSheet["D2:D5"] notation.

The sum of the values within this range is calculated using the Sum method and stored in a variable named "sum". You can also use other aggregate Excel functions like Average, Min, and Max.

The code updates cell D6 in the new worksheet with this calculated sum, and cell C6 is assigned the label "Total Price:". Finally, the modified workbook is saved back to the same file, "sample.xlsx," using the SaveAs method. For data formatting, you can apply cell data formats to display numbers as currency or percentages.

Output File

Excel spreadsheet showing a product list with quantity, price, and calculated totals, created programmatically with 'Hello World Created by IronXL' header The output file

Additional Excel Manipulation Features

Beyond basic cell editing and formulas, IronXL provides extensive features for comprehensive spreadsheet manipulation:

What Are the Key Takeaways for C# Spreadsheet Manipulation?

This article has explored the significance of C# in spreadsheet manipulation and introduced IronXL as a powerful library that enhances the capabilities of C#. Through practical examples, we've demonstrated how to create spreadsheets, edit cell values, and apply formulas without requiring Microsoft Office dependencies.

This tutorial discussed the process of creating a new Visual Studio C# project and outlined the steps to install IronXL. The article also demonstrated practical examples of using IronXL to edit Excel files, showing how to change cell values and apply formulas to spreadsheet data. For those working with different data sources, IronXL also supports importing Excel data and exporting to various formats.

IronXL proves to be a valuable tool for developers working on projects involving data analysis, reporting, and other spreadsheet-related functionalities, providing a seamless and efficient solution for exporting data in C# applications. The library's extensive API reference and tutorials make it easy to implement even complex Excel operations.

Furthermore, IronXL offers a wide range of features to interact with Excel WorkBook, WorkSheet, and Cells level such as converting between popular formats, cell data formatting, merging cells, inserting math functions, and even managing charts and adding images. The library also supports advanced operations like grouping and ungrouping rows, managing worksheets, and clearing cell contents.

The sample code and example of using formulas in spreadsheets can be found in this example. For the complete tutorial on editing spreadsheets, visit the following how-to. Additional examples are available in the code examples section, covering topics from reading Excel files to working with SQL databases.

Opt into IronXL's trial today to begin exploring all of its features and see how IronXL can help benefit your projects, whether you want to create a new Excel file, edit existing worksheets, or add new cell data to a spreadsheet or cell range. The library continues to evolve with regular updates documented in the changelog and performance improvements.

If you find IronXL beneficial to your working environment and wish to continue using its features for all your spreadsheet data manipulation needs and more, you can purchase a license once your trial ends. For enterprise deployments, explore our licensing options and available upgrades.

Frequently Asked Questions

How can you manipulate spreadsheets in C# without using Interop?

You can use the IronXL library to manipulate spreadsheets in C# without relying on Interop. IronXL allows you to perform tasks such as editing, creating, and formatting spreadsheets directly through code.

What are the initial steps for editing an Excel spreadsheet in C#?

To edit an Excel spreadsheet in C#, first install the IronXL library, then load your Excel file using WorkBook.Load. You can modify cell values using Worksheet.Value and save the changes with the SaveAs method.

How do you install IronXL in a Visual Studio project?

To install IronXL in a Visual Studio project, go to Tools > NuGet Package Manager > Manage NuGet Packages for Solution, search for IronXL, select the latest version, and click install.

What makes IronXL a powerful tool for spreadsheet manipulation in C#?

IronXL is a powerful tool for spreadsheet manipulation in C# because it allows you to perform a wide range of operations such as applying formulas, converting file formats, managing charts, and handling images without needing Microsoft Excel.

How can you perform a summation of cell values in a C# spreadsheet?

To sum cell values in a C# spreadsheet using IronXL, select the desired range with workSheet["D2:D5"], use the range.Sum() method to calculate the sum, and assign the result to a cell with workSheet["D6"].Value.

Is it possible to convert spreadsheet formats using a C# library?

Yes, using IronXL, you can easily convert spreadsheet formats. The library supports various Excel file types and allows you to save your spreadsheets in formats like .XLSX, .CSV, and others.

What are the benefits of using a trial version of a C# spreadsheet library?

The trial version of IronXL allows you to explore its wide array of features for spreadsheet data manipulation, helping you assess its capabilities for your C# projects before purchasing a full license.

Where can I find tutorials on using a C# library for spreadsheet manipulation?

You can find tutorials and examples of using IronXL for spreadsheet manipulation on their official website, particularly in their 'how-to' and 'examples' sections, which cover various features and use cases.

Jordi Bardia
Jordi Bardia
  Chat with engineering team now
Software Engineer
Jordi is most proficient in Python, C# and C++, when he isn’t leveraging his skills at Iron Software; he’s game programming. Sharing responsibilities for product testing, product development and research, Jordi adds immense value to continual product improvement. The varied experience keeps him challenged and engaged, and he ...
Read More

Related Articles

30-day trial → Full product. No limits. No card. Start Free Trial