C# MS Office Version problem

  • Thread starter Thread starter Jason Huang
  • Start date Start date
J

Jason Huang

Hi,

In our C# windows form project, we have referenced MS Excel 10.0 in our
project.
However, we have several different versions of MS Excel in our client sites.
How do we fix this problem without changing client's Excel?
Thanks for help.



Jason
 
This may be over-engineering it, but maybe you could develop a generic
interface for your needs and then create a DLL for each version of Excel
that you need to support. You could then load the relevant DLL using
reflection in your application. Not sure how you'd determine which version
of the DLL to use, if you could do it programatically or need to read it
from application configuration file. If there's no clear way to determine
which version to use, on start up I guess you could increment through the
DLL's trying each in time until you found one that worked. You may only
need to do this once as you could then update the config file with which
version to use. If you needed to support a new version you could then just
supply a new DLL to the relevant client site.
 
You could reference the 'lowest' level of Excel (you might get on
client machines) e.g. version 9.0.

cp
 
Back
Top