Manipulating Multiple Versions of Excel, c#

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matthew - 23 May 2008 20:00 GMT

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.

Reply to this Message

CLR - 23 May 2008 20:32 GMT

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

> 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.
[quoted text clipped - 15 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

Matthew - 23 May 2008 20:49 GMT

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?

> 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
[quoted text clipped - 22 lines]
> >
> > Any help would be greatly appreciated.

Reply to this Message

CLR - 23 May 2008 23:04 GMT

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

> Ah thanks, that's a good idea. It never crossed my mind to do it all in xl97,
> as it's always forwards-compatible.
[quoted text clipped - 33 lines]
> > >
> > > Any help would be greatly appreciated.

Reply to this Message