Aspose.Cells.Examples.CSharp.Articles.ManagingWorkbooksWorksheets.CheckPasswordToModify.Run C# (CSharp) Method

        public static void Run()
        {
            // ExStart:CheckPasswordToModifyUsingAsposeCells
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            // Specify password to open inside the load options
            LoadOptions opts = new LoadOptions();
            opts.Password = "1234";

            // Open the source Excel file with load options
            Workbook workbook = new Workbook(dataDir + "sampleBook.xlsx", opts);

            // Check if 567 is Password to modify
            bool ret = workbook.Settings.WriteProtection.ValidatePassword("567");
            Console.WriteLine("Is 567 correct Password to modify: " + ret);

            // Check if 5679 is Password to modify
            ret = workbook.Settings.WriteProtection.ValidatePassword("5678");
            Console.WriteLine("Is 5678 correct Password to modify: " + ret);
            // ExEnd:CheckPasswordToModifyUsingAsposeCells
        }
    }