Manipulating excel spreadsheets in C++

[spirit]

Hi,

I have C++ code to write data to a .csv file thereby resulting in an
excel spreadsheet.

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?

Thanks fr your suggestions and help,

 

[Victor Bazarov]

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.

V

 

[Default User]

Hi,

I have C++ code to write data to a .csv file thereby resulting in an
excel spreadsheet.

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?

C++ has no special features for doing that.

A csv file is just text normally. If you can figure out a spreadsheet
feature that can be captured in a csv file to do it, then you can
certainly write it to the file. I'd start with an Excel newsgroup or
forum.




Brian

 

[James Kanze]

It only results in an excel spreadsheet if you load it into MS Excel.

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.

 

[spirit]

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:[email protected]
Conseils en informatique orientée objet/
Beratung in objektorientierter Datenverarbeitung
9 place Sémard, 78210 St.-Cyr-l'École, France, +33 (0)1 30 23 00 34

thnks a lot guys for your suggestions...
James...Yea Ill go thru it and see whether I really need to do tht..