Disable Compatibility Checker in Excel Files using Java

Various versions of MS Excel are available and being used around the world. This makes it possible that the newer versions provide features that may not be available in the older ones. Therefore, MS Excel uses compatibility checker to degrade the features which are not supported by an older format when saving the files. 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 Java.
November 8, 2021 · 2 min · Usman Aziz