USING IRONXL

How to Rename Excel WorkSheet in C#

Updated April 29, 2024
Share:

Introduction

Renaming Excel files programmatically is a common task in various applications. Whether you're organizing files, automating tasks, or managing data, having the ability to rename Excel files through code can be highly beneficial. In this article, we'll explore how to rename Excel files using IronXL library from Iron Software.

How to Rename Excel WorkSheet in C#

  1. Create a Visual Studio Project to rename Excel sheets.
  2. Install IronXL library from Iron Software.
  3. Rename Excel sheets using IronXL.

IronXL library from Iron Software

IronXL is a powerful C# Excel library developed by Iron Software. It allows you to work with Excel documents in your .NET projects without the need for Microsoft Office or Excel Interop.

Key Features of IronXL

  1. Read, Edit, and Create Excel Files: IronXL enables you to read, generate, and edit Excel spreadsheet files (including XLSX, XLS, XLSM, XLTX, CSV, and TSV formats) directly from your C# or VB.NET code.
  2. No Office Interop Required: You won’t need to install Microsoft Office or deal with the complexities of Office Interop. IronXL provides a hassle-free experience.
  3. Cross-Platform Support: IronXL is designed for .NET 8, 7, 6, Core, Framework, and Azure. Whether you’re building console applications, web apps, or desktop software, IronXL has you covered.

    1. User-Friendly API: The intuitive API allows you to perform tasks like reading cell values, calculating aggregate values, working with formulas, creating charts, and more. Let’s briefly examine an example:
    using IronXL;
    namespace RenameExcelSheets;
    public class Program
    {
        public static void Main()
        {
            Console.WriteLine("Rename Excel Sheets Using IronXL");
            // Load an existing Excel file to excel workbook object
            WorkBook workBook = WorkBook.Load("sample.xlsx"); // sample excel file
            // Select specified worksheet
            WorkSheet workSheet = workBook.WorkSheets [0];
            // Read a cell value from same workbook
            int cellValue = workSheet ["A2"].IntValue;
            // Iterate through a range of cells
            foreach (var cell in workSheet ["A2:A10"])
            {
                Console.WriteLine($"Cell {cell.AddressString} has value     '{cell.Text}'");
            }
            // Calculate aggregate values
            decimal sum = workSheet ["A2:A10"].Sum();
            decimal max = workSheet ["A2:A10"].Max(c => c.DecimalValue);
            workBook.SaveAs("sampleResult.xlsx"); // save as new workbook
        }
    }
    using IronXL;
    namespace RenameExcelSheets;
    public class Program
    {
        public static void Main()
        {
            Console.WriteLine("Rename Excel Sheets Using IronXL");
            // Load an existing Excel file to excel workbook object
            WorkBook workBook = WorkBook.Load("sample.xlsx"); // sample excel file
            // Select specified worksheet
            WorkSheet workSheet = workBook.WorkSheets [0];
            // Read a cell value from same workbook
            int cellValue = workSheet ["A2"].IntValue;
            // Iterate through a range of cells
            foreach (var cell in workSheet ["A2:A10"])
            {
                Console.WriteLine($"Cell {cell.AddressString} has value     '{cell.Text}'");
            }
            // Calculate aggregate values
            decimal sum = workSheet ["A2:A10"].Sum();
            decimal max = workSheet ["A2:A10"].Max(c => c.DecimalValue);
            workBook.SaveAs("sampleResult.xlsx"); // save as new workbook
        }
    }
    Imports IronXL
    Namespace RenameExcelSheets
    	Public Class Program
    		Public Shared Sub Main()
    			Console.WriteLine("Rename Excel Sheets Using IronXL")
    			' Load an existing Excel file to excel workbook object
    			Dim workBook As WorkBook = WorkBook.Load("sample.xlsx") ' sample excel file
    			' Select specified worksheet
    			Dim workSheet As WorkSheet = workBook.WorkSheets (0)
    			' Read a cell value from same workbook
    			Dim cellValue As Integer = workSheet ("A2").IntValue
    			' Iterate through a range of cells
    			For Each cell In workSheet ("A2:A10")
    				Console.WriteLine($"Cell {cell.AddressString} has value     '{cell.Text}'")
    			Next cell
    			' Calculate aggregate values
    			Dim sum As Decimal = workSheet ("A2:A10").Sum()
    			Dim max As Decimal = workSheet ("A2:A10").Max(Function(c) c.DecimalValue)
    			workBook.SaveAs("sampleResult.xlsx") ' save as new workbook
    		End Sub
    	End Class
    End Namespace
    VB   C#
  4. Excel Functionality Without the Hassle: IronXL allows you to create, load, save, and manipulate spreadsheets effortlessly. Whether you’re dealing with metadata, permissions, formulas, or styling, IronXL simplifies the process.

Remember, IronXL is trusted by millions of engineers worldwide for its accuracy, ease of use, and speed. If you’re working with Excel files in C# or VB.NET, IronXL is your go-to library!

Setting Up the Environment

Before diving into the coding part, make sure you have the necessary tools installed:

  1. Visual Studio: Install Visual Studio or any other preferred C# IDE.
  2. Microsoft Excel: Make sure Microsoft Excel is installed on your system.

To demonstrate a real-world example of renaming an Excel file, let us write a program to take a folder containing all the files to rename and use IronXL to rename all the files, then store them in the output folder.

Step 1: Create Visual Studio Project to rename Excel sheets.

Open Visual Studio and create a new project for the demo. Select Console app from the below template.

How to Rename Excel WorkSheet in C#: Figure 1 - Creating a Console app

Provide names to the Project and path to store the files.

How to Rename Excel WorkSheet in C#: Figure 2 - Name the project

Select the required .NET version.

How to Rename Excel WorkSheet in C#: Figure 3 - Select the required .NET version

Step 2: Install IronXL library from Iron Software.

IronXL library can be installed from Visual Studio Package manager as below.

How to Rename Excel WorkSheet in C#: Figure 4 - Searching for IronXL using NuGet Package Manager

Or can be installed from NuGet Package Manager with command.

dotnet add package IronXL.Excel --version 2024.4.4
dotnet add package IronXL.Excel --version 2024.4.4
'INSTANT VB TODO TASK: The following line uses invalid syntax:
'dotnet add package IronXL.Excel --version 2024.4.4
VB   C#

How to Rename Excel WorkSheet in C#: Figure 5 - IronXL homepage

Once installed the project is ready to start coding for renaming Excel worksheets.

Step 3: Rename Excel sheets using IronXL

Below is the program to rename all the files and worksheets in a directory for business applications.

Input:

How to Rename Excel WorkSheet in C#: Figure 6 - Example Excel worksheet input for renaming

using IronXL;
namespace RenameExcelSheets;
public class Program
{
    public static void Main()
    {
        Console.WriteLine("Demo Rename Excel Sheets Using IronXL");
        Console.WriteLine("Enter Folder where Excel Files are present to rename to FinancialReport2024");
        var folderPath = Console.ReadLine();
        if (string.IsNullOrEmpty(folderPath)) // check for empty string
        {
            throw new AggregateException("Path is empty");
        }
        if (Directory.Exists(folderPath) == false)
        {
            throw new AggregateException("Path is Wrong");
        }
        var files = Directory.GetFiles(folderPath);
        var outputPath = Path.Combine(folderPath, "output");
        var index = 0;
        foreach (var file in files)
        {
            // Load an existing Excel file
            WorkBook workBook = WorkBook.Load(file);
            // Select the first worksheet (index 0)
            WorkSheet workSheet = workBook.WorkSheets [0];
            // Rename the worksheet
            workSheet.Name = "FinancialReport2024"; // change the name property
            // Save the modified workbook
            workBook.SaveAs(Path.Join(outputPath, $"FinancialReport2024_{index++}.xlsx"));
        }
    }
}
using IronXL;
namespace RenameExcelSheets;
public class Program
{
    public static void Main()
    {
        Console.WriteLine("Demo Rename Excel Sheets Using IronXL");
        Console.WriteLine("Enter Folder where Excel Files are present to rename to FinancialReport2024");
        var folderPath = Console.ReadLine();
        if (string.IsNullOrEmpty(folderPath)) // check for empty string
        {
            throw new AggregateException("Path is empty");
        }
        if (Directory.Exists(folderPath) == false)
        {
            throw new AggregateException("Path is Wrong");
        }
        var files = Directory.GetFiles(folderPath);
        var outputPath = Path.Combine(folderPath, "output");
        var index = 0;
        foreach (var file in files)
        {
            // Load an existing Excel file
            WorkBook workBook = WorkBook.Load(file);
            // Select the first worksheet (index 0)
            WorkSheet workSheet = workBook.WorkSheets [0];
            // Rename the worksheet
            workSheet.Name = "FinancialReport2024"; // change the name property
            // Save the modified workbook
            workBook.SaveAs(Path.Join(outputPath, $"FinancialReport2024_{index++}.xlsx"));
        }
    }
}
Imports IronXL
Namespace RenameExcelSheets
	Public Class Program
		Public Shared Sub Main()
			Console.WriteLine("Demo Rename Excel Sheets Using IronXL")
			Console.WriteLine("Enter Folder where Excel Files are present to rename to FinancialReport2024")
			Dim folderPath = Console.ReadLine()
			If String.IsNullOrEmpty(folderPath) Then ' check for empty string
				Throw New AggregateException("Path is empty")
			End If
			If Directory.Exists(folderPath) = False Then
				Throw New AggregateException("Path is Wrong")
			End If
			Dim files = Directory.GetFiles(folderPath)
			Dim outputPath = Path.Combine(folderPath, "output")
			Dim index = 0
			For Each file In files
				' Load an existing Excel file
				Dim workBook As WorkBook = WorkBook.Load(file)
				' Select the first worksheet (index 0)
				Dim workSheet As WorkSheet = workBook.WorkSheets (0)
				' Rename the worksheet
				workSheet.Name = "FinancialReport2024" ' change the name property
				' Save the modified workbook
'INSTANT VB WARNING: An assignment within expression was extracted from the following statement:
'ORIGINAL LINE: workBook.SaveAs(Path.Join(outputPath, string.Format("FinancialReport2024_{0}.xlsx", index++)));
				workBook.SaveAs(Path.Join(outputPath, $"FinancialReport2024_{index}.xlsx"))
				index += 1
			Next file
		End Sub
	End Class
End Namespace
VB   C#

Code Explanation

  1. Take Folder path to rename all the files and their worksheets
  2. Check if Folder path is an empty string
  3. Check if Folder path is valid
  4. Get all the files in the folder with xlsx extension
  5. Iterate through the files and load to WorkBook object from IronXL to rename the worksheet name property.
  6. Save the file to Output folder

Output

In the below output, you can see all the 3 files are renamed and the Excel sheet inside them is also renamed to FinancialReport2024.

How to Rename Excel WorkSheet in C#: Figure 7 - Example output showcasing all the Excel worksheets being renamed using IronXL

Advantages of renaming Excel sheets programmatically include

  • Efficiency: Automation reduces manual effort and human errors associated with manual renaming, saving time and resources.
  • Consistency: Automated renaming ensures uniformity and adherence to naming conventions across sheets, enhancing data organization and readability.
  • Scalability: Programmatically renaming sheets allows for bulk renaming and scalability, making it suitable for handling large datasets or repetitive tasks.
  • Integration: Integration with existing workflows or applications enables seamless data processing and enhances overall productivity.
  • Customization: Automation provides flexibility to customize renaming logic based on specific business requirements or criteria.

Licensing

IronXL is an enterprise library that works with a license agreement. More on license can be found here. The license key needs to be placed in the appsettings.json file here.

{
  "IronXL.License.LicenseKey" : "IRONXL-MYLICENSE-KEY-1EF01"
}
{
  "IronXL.License.LicenseKey" : "IRONXL-MYLICENSE-KEY-1EF01"
}
If True Then
  "IronXL.License.LicenseKey" : "IRONXL-MYLICENSE-KEY-1EF01"
End If
VB   C#

Conclusion

Renaming Excel files using C# is a straightforward process. By leveraging the IronXL library from Iron Software, you can easily rename Excel files within your C# applications. This library is a handy tool for developers for all Excel sheet operations, be it reading, writing, or managing.

Now that you've learned how to rename Excel files programmatically, you can incorporate this feature into your C# projects to streamline file management tasks and improve automation capabilities.

< PREVIOUS
How to Use C# Excel Font Style
NEXT >
How to Read an Excel File in a C# Console Application

Ready to get started? Version: 2024.6 just released

Start Free Trial Total downloads: 853,944
View Licenses >