How to Manage Worksheets

using IronXL;

// Create a new Excel workbook in the XLSX format
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Create multiple worksheets within the workbook
// Each call to CreateWorkSheet initializes a new worksheet with the specified name
WorkSheet workSheet1 = workBook.CreateWorkSheet("WorkSheet1"); // First worksheet named "WorkSheet1"
WorkSheet workSheet2 = workBook.CreateWorkSheet("WorkSheet2"); // Second worksheet named "WorkSheet2"
WorkSheet workSheet3 = workBook.CreateWorkSheet("WorkSheet3"); // Third worksheet named "WorkSheet3"
WorkSheet workSheet4 = workBook.CreateWorkSheet("WorkSheet4"); // Fourth worksheet named "WorkSheet4"

// Save the workbook with the worksheets to a file named "createNewWorkSheets.xlsx"
workBook.SaveAs("createNewWorkSheets.xlsx");

Imports IronXL



' Create a new Excel workbook in the XLSX format

Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Create multiple worksheets within the workbook

' Each call to CreateWorkSheet initializes a new worksheet with the specified name

Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("WorkSheet1") ' First worksheet named "WorkSheet1"

Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("WorkSheet2") ' Second worksheet named "WorkSheet2"

Private workSheet3 As WorkSheet = workBook.CreateWorkSheet("WorkSheet3") ' Third worksheet named "WorkSheet3"

Private workSheet4 As WorkSheet = workBook.CreateWorkSheet("WorkSheet4") ' Fourth worksheet named "WorkSheet4"



' Save the workbook with the worksheets to a file named "createNewWorkSheets.xlsx"

workBook.SaveAs("createNewWorkSheets.xlsx")

// Import the IronXL library to work with Excel files
using IronXL;

// Load an existing workbook from a file named "createNewWorkSheets.xlsx"
WorkBook workBook = WorkBook.Load("createNewWorkSheets.xlsx");

// Set the position of the worksheet named "workSheet2" to be the first sheet in the workbook
// The sheet index is zero-based, so 0 refers to the first position
try
{
    // Method assumes that the workbook contains a sheet named "workSheet2"
    // and ensures "workSheet2" is placed at index 0
   
    workBook.SetWorksheetPosition("workSheet2", 0);
}
catch(Exception e)
{
    // Log or handle the error appropriately if the sheet is not found 
    // or other exceptions arise
    Console.WriteLine($"An error occurred: {e.Message}");
}

// Save the modified workbook to a new file named "setWorksheetPosition.xlsx"
try
{
    // Save changes to a new file preserving the original file 
    workBook.SaveAs("setWorksheetPosition.xlsx");
}
catch(Exception e)
{
    // Log or handle any errors that occur during saving
    Console.WriteLine($"An error occurred while saving the file: {e.Message}");
}

' Import the IronXL library to work with Excel files

Imports IronXL



' Load an existing workbook from a file named "createNewWorkSheets.xlsx"

Private workBook As WorkBook = WorkBook.Load("createNewWorkSheets.xlsx")



' Set the position of the worksheet named "workSheet2" to be the first sheet in the workbook

' The sheet index is zero-based, so 0 refers to the first position

Try

	' Method assumes that the workbook contains a sheet named "workSheet2"

	' and ensures "workSheet2" is placed at index 0



	workBook.SetWorksheetPosition("workSheet2", 0)

Catch e As Exception

	' Log or handle the error appropriately if the sheet is not found 

	' or other exceptions arise

	Console.WriteLine($"An error occurred: {e.Message}")

End Try



' Save the modified workbook to a new file named "setWorksheetPosition.xlsx"

Try

	' Save changes to a new file preserving the original file 

	workBook.SaveAs("setWorksheetPosition.xlsx")

Catch e As Exception

	' Log or handle any errors that occur during saving

	Console.WriteLine($"An error occurred while saving the file: {e.Message}")

End Try

using IronXL;

// Load the Excel workbook from the specified file path
WorkBook workBook = WorkBook.Load("createNewWorkSheets.xlsx");

// Check if the workbook has at least three worksheets
if (workBook.WorkSheets.Count > 2)
{
    // Set the third worksheet (zero-based index, so index 2 is the third sheet) as active
    workBook.SetActiveSheet(2);
}
else
{
    // If there are less than three worksheets, log a message or handle the error
    Console.WriteLine("The workbook does not contain enough worksheets to set the third one as active.");
}

// Save the changes to a new Excel file
workBook.SaveAs("setActiveTab.xlsx");

Imports IronXL



' Load the Excel workbook from the specified file path

Private workBook As WorkBook = WorkBook.Load("createNewWorkSheets.xlsx")



' Check if the workbook has at least three worksheets

If workBook.WorkSheets.Count > 2 Then

	' Set the third worksheet (zero-based index, so index 2 is the third sheet) as active

	workBook.SetActiveSheet(2)

Else

	' If there are less than three worksheets, log a message or handle the error

	Console.WriteLine("The workbook does not contain enough worksheets to set the third one as active.")

End If



' Save the changes to a new Excel file

workBook.SaveAs("setActiveTab.xlsx")

using IronXL;

// Load the Excel workbook from a file
WorkBook workBook = WorkBook.Load("createNewWorkSheets.xlsx");

// Remove the first worksheet by index
// Indices are zero-based, so 0 refers to the first sheet.
workBook.RemoveWorkSheet(0);

// Remove the worksheet named "workSheet2"
// This method removes the worksheet by its name.
workBook.RemoveWorkSheet("workSheet2");

// Save the edited workbook to a new file
workBook.SaveAs("removeWorksheet.xlsx");

Imports IronXL



' Load the Excel workbook from a file

Private workBook As WorkBook = WorkBook.Load("createNewWorkSheets.xlsx")



' Remove the first worksheet by index

' Indices are zero-based, so 0 refers to the first sheet.

workBook.RemoveWorkSheet(0)



' Remove the worksheet named "workSheet2"

' This method removes the worksheet by its name.

workBook.RemoveWorkSheet("workSheet2")



' Save the edited workbook to a new file

workBook.SaveAs("removeWorksheet.xlsx")

using IronXL;

// Create a new workbook with a specified Excel file format (XLSX in this case).
WorkBook firstBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Create a second workbook with the default Excel file format.
WorkBook secondBook = WorkBook.Create();

// Select the default/first worksheet in the first workbook.
WorkSheet workSheet = firstBook.DefaultWorkSheet;

// Duplicate the worksheet within the same workbook; the new sheet will be named "Copied Sheet".
workSheet.CopySheet("Copied Sheet");

// Duplicate the worksheet to the second workbook and name it "Copied Sheet".
workSheet.CopyTo(secondBook, "Copied Sheet");

// Save the first workbook to a file named "firstWorksheet.xlsx".
firstBook.SaveAs("firstWorksheet.xlsx");

// Save the second workbook to a file named "secondWorksheet.xlsx".
secondBook.SaveAs("secondWorksheet.xlsx");

Imports IronXL



' Create a new workbook with a specified Excel file format (XLSX in this case).

Private firstBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Create a second workbook with the default Excel file format.

Private secondBook As WorkBook = WorkBook.Create()



' Select the default/first worksheet in the first workbook.

Private workSheet As WorkSheet = firstBook.DefaultWorkSheet



' Duplicate the worksheet within the same workbook; the new sheet will be named "Copied Sheet".

workSheet.CopySheet("Copied Sheet")



' Duplicate the worksheet to the second workbook and name it "Copied Sheet".

workSheet.CopyTo(secondBook, "Copied Sheet")



' Save the first workbook to a file named "firstWorksheet.xlsx".

firstBook.SaveAs("firstWorksheet.xlsx")



' Save the second workbook to a file named "secondWorksheet.xlsx".

secondBook.SaveAs("secondWorksheet.xlsx")