MS Excel compatibility checker prevents newer features from being used in older file formats, ensuring that users of older Excel versions do not encounter compatibility problems. When working with Excel files programmatically, you may need to turn this checker on or off. This article explains 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 spreadsheet manipulation API. It offers both basic and advanced features for creating and editing MS Excel files. We will use this library to enable or disable the compatibility checker. You can either download the API or install it with pip.
> pip install aspose-cells
Disable Excel Compatibility Checker in Python
To change the compatibility checker setting, update the workbook’s settings:
- Load the Excel file with the Workbook class.
- Call Workbook.getSettings().setCheckCompatibility(boolean) (set True to enable, False to disable).
- Save the workbook using Workbook.save(string).
The code sample below demonstrates how to disable the compatibility checker in Python.
Python Excel Library - Get a Free License
You can remove evaluation limits by obtaining a free temporary license.
Read More - Python Library for Excel Compatibility Checker
Explore additional Aspose.Cells for Python features in the documentation. For questions, visit our forum.
Conclusion
The Excel compatibility checker blocks newer features in older file formats. This article showed how to disable the checker in Excel files using Python.