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]

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.

V
--
Please remove capital 'A's when replying by e-mail
I do not respond to top-posted replies, please don't ask

[Default User]

spirit wrote:

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]

On Jul 19, 8:39 pm, "Victor Bazarov" <[e-mail]:

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:ja*********@gmail.com
Conseils en informatique orientée objet/
Beratung in objektorientierter Datenverarbeitung
9 place Sémard, 78210 St.-Cyr-l'École, France, [phone]

[spirit]

On Jul 20, 3:08 am, James Kanze <[e-mail]:

On Jul 19, 8:39 pm, "Victor Bazarov" <[e-mail]:

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:[e-mail]
Conseils en informatique orientée objet/
Beratung in objektorientierter Datenverarbeitung
9 place Sémard, 78210 St.-Cyr-l'École, France, [phone]

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