c# - How to make Windows forms app to support Older versions of MS Office?

Question

I need to develop a windows app program. I have Office 2013 in my Machine. And I need to develop the app which supports Office 2013 User machine also. How to do reference dll for it?

I expect that I will develop using Office 2013 and it should supports(the app should work) on Office 2010 also

I have made the app with excel 14.0 reference file. So that if a machine have excel 2010, then the app couldn't open on that

标签： c#excelvb.netexcel-2010excel-2013

Answer 1

Things go the other way around with Office!

To support all versions of Office back to 2010, you have to develop and maintain your WinForms application with Office 2010, that is the oldest version of Office that you want to support. Whenever you deploy your application on a machine that has Office 2010 or a more recent version, it will work. But it will fail with older versions such as 2007 and 2003.

This design makes sense since one cannot expect that a workook developed with say, Excel 2016, can be run by Excel 2010 without error. The 2016 workbook may use features that did not exist in 2010.