Version Problem with Excel

  • Thread starter Thread starter Altruist
  • Start date Start date
A

Altruist

Hi,
I am using Excel Library in my .Net Application. What would happen if the
version on my machine does not match with the version of Excel that is being
used on the machine where my application is installed. For eg the SaveAs
method of Version 10 has 12 parameters and that in Version 9 has only 11.
How do I tackle such problems. What precautions do I have to take during
deployment?

Thanks
Jnans
 
Jnans,

Unfortunately, there is no really simple way of dealing with this. The
best way to probably deal with this (from a maintinence point of view) would
be to use VB.NET, and then make all the calls late bound. This way, you
don't have to worry about version differences.

Technically, you should be able to use the lowest common denominator
(version), and then use the interfaces from that. Then, you use interfaces
and not class definitions to access members, and then use a class factory to
create the appropriate version, casting it to the interface.

Hope this helps.
 
Hi,

What you can also do is check which version of office or excel specifically
is
installed on the clients machine and based on that call the save function.

Thanks
Archie
 
Back
Top