Thanks for the advise. Actually, I need to do this programmatically (using
c#) or by some command line utility (that I can script in a command file),
because I don't have excel on the machines on which I need to do this.
Or maybe you can suggest me of some way of creating excel files
programmatically (using c#), without using actual excel, which can be read by
excel 2000. I know of three ways to do this :-
1. Using .NET Office automation API, but this requires presence of excel on
the machine.
2. Using ODBC, but this doesn't allow formatting of cells e.g. Color, font
size, etc.
3. Creating xml files based on the schema understood by excel 2003, but my
clients have excel 2000.
Your advise and help is greatly appreciated.
Thanks,
ac.