Manipulating Multiple Versions of Excel, c#

M

Matthew

I just finished my project with Studio 2008, Excel 2007, and C#. I read a csv
file, parse the data, and enter it into a formatted excel spreadsheet.

I just learned that it's going to need to be functional for all versions of
excel after 97, however.

I Wrote it specifically for 2007.

How would any of you recommend doing this?

I have the code written, but I doubt it's going to work on previous versions..

Right now i'm using the Excel 12.0 object library. Is there a library that
will handle multiple versions?

The reason is that my client base may have anywhere from excel 97 to 2007
installed, and there is a wide group.

Any help would be greatly appreciated.
 
C

CLR

I have a similar situation, except I write small programs for xl97 to Xp
versions. I have less toruble if I just write everything in 97.......so far
it all runs on the later versions....

Vaya con Dios,
Chuck, CABGx3
 
M

Matthew

Ah thanks, that's a good idea. It never crossed my mind to do it all in xl97,
as it's always forwards-compatible.

I'm not using any new features of 07, so that should work.

If you don't mind my asking, how do I go about getting the api's for 97? I
assume i'm going to have to install Office 1997 and then find the correct
api's..

Is there a com object specifically for 97?
 
C

CLR

I'm afraid you're beyond my skill level with those questions
Matthew.......perhaps someone else can help with them. I just have the
three versions of Excel installed on my computer at work, and write all my
code in 97.

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top