Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how to auto generate an excel format file contains formula using C

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-generate OUTLOOK email based upon EXCEL Workbook data Henn9660 Excel Discussion (Misc queries) 3 April 11th 08 08:05 PM
Auto format a csv file? Frank[_3_] Excel Worksheet Functions 2 May 27th 07 10:16 PM
excel table auto format total row should see sum formula already Chris Lampard Excel Worksheet Functions 0 May 26th 06 01:21 PM
How can generate an executable file from Excel? Ofigomez Excel Discussion (Misc queries) 4 October 25th 05 01:17 PM
Can excel recognize a word and auto format a formula, on diffe she brooke Excel Worksheet Functions 0 October 20th 05 08:11 PM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"