MS Excel compatibility checker ensures that a file in an older format does not use the features provided by the newer Excel version. Thus, people using older versions of Excel do not face compatibility issues. While manipulating Excel files, you may need to disable the compatibility checker dynamically. To achieve it, this article shows how to disable the compatibility checker for MS Excel workbooks in Python.
Disable Excel Compatibility Checker - Python Library
Aspose.Cells for Python is a powerful and feature-rich spreadsheet manipulation API. It provides basic as well as advanced features to create and manipulate MS Excel files. We will use this library to enable or disable the compatibility checker in Excel files. You can either download the API or install it using the following pip command.
> pip install aspose-cells
Disable Excel Compatibility Checker in Python
To enable or disable the compatibility checker for an Excel file, you need to update the workbook’s settings. The following are the steps to perform this operation.
- First, load the Excel file using Workbook class.
- Then, disable the compatibility checker using Workbook.getSettings().setCheckCompatibility(boolean) method (set True and False to enable and disable the checker, respectively).
- Finally, save the updated workbook using Workbook.save(string) method.
The following code sample shows how to disable the compatibility checker using Python.
Python Excel Library - Get a Free License
You can disable the Excel compatibility checker without evaluation limitations using a free temporary license.
Read More - Python Library for Excel Compatibility Checker
You can also explore other features of Aspose.Cells for Python using the documentation. In case you would have any queries, you can post on our forum.
Conclusion
MS Excel compatibility checker restricts the users to use newer features in an older version of an Excel file. In this article, you have seen how to disable the compatibility checker in Excel files using Python.