Skip to content

Instantly share code, notes, and snippets.

@aspose-com-gists

aspose-com-gists/disable-excel-compatibility-checker.py

Last active February 16, 2022 06:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aspose-com-gists/8e93f456ca967bd7c9781069dd22a49b to your computer and use it in GitHub Desktop.
Save aspose-com-gists/8e93f456ca967bd7c9781069dd22a49b to your computer and use it in GitHub Desktop.
Download ZIP
Enable or Disable Compatibility Checker in Excel in Python
Raw
readme.md
Raw
disable-excel-compatibility-checker.py
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook
# load Excel workbook
wb = Workbook("workbook.xls")
# disable compatibility
wb.getSettings().setCheckCompatibility(False)
# save workbook
wb.save("workbook_disabled_compatibility.xls")
print("Done...")
jpype.shutdownJVM()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment