Spreadsheet Unlocker

The Sheetize Spreadsheet Unlocker for .NET provides the capability to remove protection from spreadsheets, allowing developers to edit or reformat locked content.

Key Features

Unlock Protected Spreadsheets

Remove password protection or sheet-level locking to enable modifications to the spreadsheet.

Detailed Guide

Unlocking a Protected Spreadsheet

To unlock a protected spreadsheet:

  1. Initialize the Unlocker: Create an instance of SpreadsheetUnlocker.
  2. Provide Unlocking Credentials: Set the password or specify other unlocking parameters.
  3. Define Input and Output Paths: Set the paths for the input locked file and the output unlocked file.
  4. Execute the Unlocking: Call the Process method to unlock the file.

Example: Unlock an XLSX File

// Step 1: Initialize the Spreadsheet Unlocker
var unlocker = new SpreadsheetUnlocker();

// Step 2: Set unlocking credentials
var options = new UnlockerLoadOptions();
options.Password = "password123";

// Step 3: Set file paths
options.AddInput(new FileDataSource("locked_input.xlsx"));
options.AddOutput(new FileDataSource("unlocked_output.xlsx"));

// Step 4: Run the unlocking process
unlocker.Process(options);

The Spreadsheet Unlocker is useful for developers needing to programmatically modify protected spreadsheets.

 English