MBXLSX

[MbarkT3STO]

Definition :

For a special encryption and decryption for Excel files

State :

Static class

Methods :

Method	Description	Returns data type	Overloads
Encrypt	Encrypt an Excel file using a custom Key and/or IV	XlEncryptionModel	6
EncryptWithoutKey	Encrypt an Excel file without Key and IV	XlEncryptionModel	2
Decrypt	Decrypt an encrypted Excel file using a custom Key and/or IV used in encryption operation	XlDecryptionModel	2
DecryptWithoutKey	Decrypt an encrypted Excel file using EncryptWithoutKey method	XlDecryptionModel	-

Details :

Encrypt

Encrypt an Excel file using a custom Key and/or IV

1st three overloads

Parameter	Description	Case	Type	Rules
WorkbookBytes	Excel File to be encrypted as Bytes	Required	Byte[]	-
Key	Your key	Optional	Byte[]	Should be 8 bytes
IV	Your IV	Optional	Byte[]	-

2nd three overloads

Parameter	Description	Case	Type	Rules
WorkbookPath	Excel File path to be encrypted	Required	String	-
Key	Your key	Optional	Byte[]	Should be 8 bytes
IV	Your IV	Optional	Byte[]	-

EncryptWithoutKey

Encrypt an Excel file without Key and IV

1st Overload

Parameter	Description	Case	Type	Rules
WorkbookBytes	Excel File to be encrypted as Bytes	Required	Byte[]	-

2nd Overload

Parameter	Description	Case	Type	Rules
WorkbookPath	Excel File path to be encrypted	Required	String	-

Decrypt

Decrypt an encrypted Excel file bytes using a custom Key and/or IV used in the encryption operation

Parameter	Description	Case	Type	Rules
EncryptedWorkbook	Encrypted Excel file bytes to be decrypted	Required	Byte[]	A Bytes value already encrypted using MBSecurity
Key	Your key	Required	Byte[]	The encrypted Key used in encryption
IV	Your IV	Optional	Byte[]	The same IV used in encryption

• Note : the Key parameter in decryption should converted from base 64 string to bytes, to do that when sending the key use .FromBase64ToBytes() extension method provided by MBSecurity.

DecryptWithoutKey

Decrypt an Excel file encrypted using EncryptWithoutKey method

Parameter	Description	Case	Type	Rules
EncryptedWorkbook	Encrypted Excel file bytes to be decrypted	Required	Byte[]	A Bytes value already encrypted using MBSecurity

Important notes

• One only case to use DecryptWithoutKey method, if you encrypt your data using EncryptWithoutKey
• If you encrypt your data whether Encrypt or EncryptWithoutKey you will get a value type XlEncryptionModel has two properties (Key and EncryptedBytes)
• The Key is your or auto-generated key used in encryption
• The Key returned after encryption is encrypted