Class SpreadsheetLocker
Class SpreadsheetLocker
Lokasi file spreadsheet
public class SpreadsheetLocker
Inheritance
anggota yang diwarisi
- 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(Lokasi dan LockerSaveOptions)
.
public static void Process(LoadOptions loadOptions, LockerSaveOptions saveOptions)
Parameters
loadOptions
LoadOptions Pilihan untuk input dan loading:saveOptions
LockerSaveOptions : Opsi untuk output dan simpanan
Remarks
File yang disimpan kembali setelah dikunci akan selalu memiliki format yang sama dengan file sumber.
Nama dari : Sheetize Perhimpunan Agung : Sheetize.dll