Class SpreadsheetLocker
Class SpreadsheetLocker
Locks Spreadsheet Datei
public class SpreadsheetLocker
Inheritance
Vererbte Mitglieder
- object.GetType() ,
- object.MemberwiseClone() ,
- object.ToString() ,
- object.Equals(object?) ,
- object.Equals(object?, object?) ,
- object.ReferenceEquals(object?, object?) ,
- object.GetHashCode()
Examples
[C#]
private class MyLockerSaveOptions : LockerSaveOptions
{
public override ProtectionSettings GetPasswordOfWorksheetProtection(SplitPartInfo info)
{
if (info.SheetName == "ToProtect")
{
ProtectionSettings ps = new ProtectionSettings();
ps.Password = "123456";
ps.ProtectionType = ProtectionType.All;
return ps;
}
return null;
}
}
SpreadsheetLocker processor = new SpreadsheetLocker();
LoadOptions loadOptions = new LoadOptions();
loadOptions.InputFile = "Template.xlsx";
MyLockerSaveOptions saveOptions = new MyLockerSaveOptions();
saveOptions.Password = "password to lock file";
saveOptions.OutputFile = "res_locked.xlsx";
SpreadsheetLocker.Process(loadOptions, saveOptions);
Methods
Process(LoadOptions, LockerSaveOptionen)
.
public static void Process(LoadOptions loadOptions, LockerSaveOptions saveOptions)
Parameters
loadOptions
LoadOptions : Optionen für Eingang und Ladung:saveOptions
LockerSaveOptions : Optionen für Produktion und Einsparung
Remarks
Die neu gespeicherte Datei, nachdem sie gesperrt wird, hat immer das gleiche Format wie die Quelldatei.
Der Name: Sheetize Verabschiedung der Versammlung: Sheetize.dll