Workbook.SetPasswordEncryptionOptions Method
Sets the options for encrypting the workbook using a password.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Sub SetPasswordEncryptionOptions ( _
PasswordEncryptionProvider As Object, _
PasswordEncryptionAlgorithm As Object, _
PasswordEncryptionKeyLength As Object, _
PasswordEncryptionFileProperties As Object _
)
void SetPasswordEncryptionOptions(
Object PasswordEncryptionProvider,
Object PasswordEncryptionAlgorithm,
Object PasswordEncryptionKeyLength,
Object PasswordEncryptionFileProperties
)
Parameters
PasswordEncryptionProvider
Type: System.ObjectA case sensitive string of the encryption provider.
PasswordEncryptionAlgorithm
Type: System.ObjectA case sensitive string of the algorithmic short name (i.e. "RC4").
PasswordEncryptionKeyLength
Type: System.ObjectThe encryption key length, which is a multiple of 8 (40 or greater).
PasswordEncryptionFileProperties
Type: System.Objecttrue (default) to encrypt file properties.
Remarks
The PasswordEncryptionProvider, PasswordEncryptionAlgorithm, and PasswordEncryptionKeyLength parameters are not independent of each other. A selected encryption provider limits the set of algorithms and key length that can be chosen.
For the PasswordEncryptionKeyLength parameter there is no inherent limit on the range of the key length. The range is determined by the Cryptographic Service Provider which also determines the cryptographic algorithm.
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.