如何在 C# 中重命名 Excel 工作表

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.

4. 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 into a WorkBook object
               WorkBook workBook = WorkBook.Load("sample.xlsx"); // sample excel file
   
               // Select the specified worksheet (first sheet)
               WorkSheet workSheet = workBook.WorkSheets[0];
   
               // Read a cell value from the workbook
               int cellValue = workSheet["A2"].IntValue;
   
               // Iterate through a range of cells and print their values
               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);
   
               // Save as a new workbook
               workBook.SaveAs("sampleResult.xlsx");
           }
       }
   }

   using IronXL;
   
   namespace RenameExcelSheets
   {
       public class Program
       {
           public static void Main()
           {
               Console.WriteLine("Rename Excel Sheets Using IronXL");
   
               // Load an existing Excel file into a WorkBook object
               WorkBook workBook = WorkBook.Load("sample.xlsx"); // sample excel file
   
               // Select the specified worksheet (first sheet)
               WorkSheet workSheet = workBook.WorkSheets[0];
   
               // Read a cell value from the workbook
               int cellValue = workSheet["A2"].IntValue;
   
               // Iterate through a range of cells and print their values
               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);
   
               // Save as a new workbook
               workBook.SaveAs("sampleResult.xlsx");
           }
       }
   }

   Imports IronXL
   
   Namespace RenameExcelSheets
   	Public Class Program
   		Public Shared Sub Main()
   			Console.WriteLine("Rename Excel Sheets Using IronXL")
   
   			' Load an existing Excel file into a WorkBook object
   			Dim workBook As WorkBook = WorkBook.Load("sample.xlsx") ' sample excel file
   
   			' Select the specified worksheet (first sheet)
   			Dim workSheet As WorkSheet = workBook.WorkSheets(0)
   
   			' Read a cell value from the workbook
   			Dim cellValue As Integer = workSheet("A2").IntValue
   
   			' Iterate through a range of cells and print their values
   			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)
   
   			' Save as a new workbook
   			workBook.SaveAs("sampleResult.xlsx")
   		End Sub
   	End Class
   End Namespace

   $vbLabelText   $csharpLabel
5. 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.

Code Explanation

1. The program prompts the user to enter a folder path where Excel files are located.
2. It checks if the folder path is an empty string and if the folder actually exists.
3. It retrieves all the files from the specified folder.
4. It iterates through these files, loading each one into a WorkBook object from the IronXL library.
5. For each workbook, it renames the first worksheet.
6. It saves each modified workbook in an "output" folder within the original 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.