WorkbookSettings.Password

WorkbookSettings.Password property

Represents Workbook file encryption password.

public string Password { get; set; }

Examples

// Called: wb.Settings.Password = "xixi";
public void WorkbookSettings_Property_Password()
{
    LoadOptions loadOptions = new LoadOptions();
    Workbook wb = new Workbook(Constants.sourcePath + "example.ods", loadOptions);
    Assert.AreEqual("test encrypt.", wb.Worksheets[0].Cells["C6"].Value);
    wb.Settings.Password = "xixi";

    wb.Save(Constants.destPath + "example.ods");

    loadOptions.Password = "xixi";
    wb = new Workbook(Constants.destPath + "example.ods", loadOptions);
    Assert.AreEqual("test encrypt.", wb.Worksheets[0].Cells["C6"].Value);
}

See Also