PC Review


Reply
Thread Tools Rate Thread

how to auto generate an excel format file contains formula using C

 
 
=?Utf-8?B?Q2VsaXU=?=
Guest
Posts: n/a
 
      4th Mar 2007
hi,
now i have a problem, i want to auto create an excel file using C++ language.

i have an data.log file, and the format list below:
1,3,0,...,1,2,
.....
2,0,0,...,3,1,

i want to wirte an C++ program that can read the data.log, anlyse it and
then write the datas to EXCEL format files with formula, like:
get line 1 in data.log, and the first value "1" write to A1, and "3" to
B1,"0" to C1,etc
get line 2 in data.log, and the first value to A2,then the sencond to
B2,...etc.

and addition, i want to set the grid width and height to 15.75, also i want
to set some formule to those cell which contains datas, the formule is: if
the value greater than 0, then the background color of the cell is red else
is green.


so if i want to using C++ complete this task, which tools or libs i need?
and how to do? Is there anything tutorial ?

thanks in advance
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel table auto format total row should see sum formula already =?Utf-8?B?Q2hyaXMgTGFtcGFyZA==?= Microsoft Excel Worksheet Functions 0 26th May 2006 01:21 PM
excel- want to format cell formula to the file name =?Utf-8?B?amFja19tZWw=?= Microsoft Excel Worksheet Functions 3 5th May 2006 03:32 PM
Can excel recognize a word and auto format a formula, on diffe she =?Utf-8?B?YnJvb2tl?= Microsoft Excel Worksheet Functions 0 20th Oct 2005 08:11 PM
Auto generate file number =?Utf-8?B?U29ueWE=?= Microsoft Word Document Management 2 13th Apr 2004 11:31 AM
Prevent excel to auto format and auto apply formula to a cell when opening a file MikeVince Microsoft Excel Misc 2 27th Feb 2004 02:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:35 PM.