Encrypt and Decrypt Excel files

Microsoft Excel (97 – 365) enables you to encrypt and password‑protect your spreadsheets. It uses algorithms provided by a cryptographic service provider (CSP), a set of cryptographic algorithms with different properties. The default CSP is Office 97/2000 Compatible or Weak Encryption (XOR). It’s important to choose the proper encryption key length. Some CSPs don’t support more than 40 or 56 bits, which is considered weak encryption. For strong encryption, a minimum key length of 128 bits is required. Microsoft Windows contains CSPs that offer strong encryption types as well, for example the Microsoft Strong Cryptographic Provider. To give you an idea, 128‑bit encryption is what banks use to encrypt the connection with their Internet Banking systems.

Aspose.Cells for Python via .NET allows you to encrypt and password‑protect Microsoft Excel files with your desired encryption type.

Using Microsoft Excel

To set file‑encryption settings in Microsoft Excel (e.g., Microsoft Excel 2003):

1. From the Tools menu, select Options. A dialog will appear.
2. Select the Security tab.
3. Input a password and click Advanced.
4. Choose the encryption type and confirm the password.

Encrypting Excel file with Aspose.Cells

The following example shows how to encrypt and password‑protect an Excel file using the Aspose.Cells for Python via .NET API.

Specifying the “Password to modify” Option

The following example shows how to set the Password to modify option in Microsoft Excel for an existing file using the Aspose.Cells for Python via .NET API.

Decrypting Excel file with Aspose.Cells

It is very easy to open a password‑protected Excel file and decrypt it using the Aspose.Cells for Python via .NET API, as shown in the following code:

Advanced topics

• Encrypt And Decrypt ODS files
• Setting Strong Encryption Type
• Specify Author while Write Protecting Workbook
• Verify Password of Encrypted Files