Re: Manipulating excel spreadsheets in C++
On Jul 19, 8:39 pm, "Victor Bazarov" <v.Abaza...@comAcast.net> wrote:
spirit wrote:
I have C++ code to write data to a .csv file thereby resulting in an
excel spreadsheet.
It only results in an excel spreadsheet if you load it into MS Excel.
I was just wondering whether it wud be possible for us to further
manipulate the csv file like for example filling a cell with a
particular color etc...with C++ code?
AFAIK Excel and csv, no. But do find a newsgroup about Excel
programming (see 'microsoft.public.*' hierarchy) and ask there.
There's a site, http://www.wotsit.org/, which has descriptions
of the format of just about every file imaginable, so if he
really has to, he can skip the CSV, and write an Excel file
directly. That should allow anything that Excel can save from
one session to the next. It's doubtlessly a lot more work than
writing a CSV file, however, and a lot more difficult to debug;
I wouldn't recommend it unless absolutely necessary.
--
James Kanze (GABI Software) email:james.kanze@gmail.com
Conseils en informatique orient=E9e objet/
Beratung in objektorientierter Datenverarbeitung
9 place S=E9mard, 78210 St.-Cyr-l'=C9cole, France, +33 (0)1 30 23 00 34