Un-Protect all worksheets with in a Workbook in C#

un-protect-all-worksheets-with-in-a-workbook.cs

using FileFormat.Cells;

class Program
{
    static void Main(string[] args)
    {
        // Define the path to the existing spreadsheet
        string filePath = "Z:\\Downloads\\test_spreadsheet.xlsx";

        // Open the existing workbook specified by the filePath
        using (Workbook wb = new Workbook(filePath))
        {
            // Iterate through each worksheet in the workbook
            foreach (var worksheet in wb.Worksheets)
            {
                // Check if the current worksheet is protected
                if (worksheet.IsProtected())
                {
                    // Display the name of the protected worksheet
                    Console.WriteLine("Protect Sheet Name = " + worksheet.Name);
                    
                    // Remove protection from the current worksheet
                    worksheet.UnprotectSheet();
                }
            }

            // Save the changes made to the workbook back to the file
            wb.Save(filePath);
        }
    }
}