Ho to check the installe Excel capabilities programatically?
Posted on 2011-09-06
The question is namely for MS Excel experts. I have implemented the data export to the Excel format via the Excel 2007 interface. It works fine. The problem is that the application will be installed on computers with possibly older versions of Excel. I know how to check the version of the installed Excel; however, some older versions of the Excel may have installed the Microsoft Office Compatibility Pack that allows export to the newer formats. How can I be sure that the chosen form of the export can be done on the computer?
To be more specific. How can I check that the SaveAs method will accept saving the document in .xlsx format?
Also, the Excel 2007 weakened the limitation to the number of columns and rows. I assume that the earlier versions of Excel still have the more strict limitation even if they support the newer format (xlsx). Can you confirm that?
Thanks for your time and experience,