Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-generate OUTLOOK email based upon EXCEL Workbook data | Excel Discussion (Misc queries) | |||
Auto format a csv file? | Excel Worksheet Functions | |||
excel table auto format total row should see sum formula already | Excel Worksheet Functions | |||
How can generate an executable file from Excel? | Excel Discussion (Misc queries) | |||
Can excel recognize a word and auto format a formula, on diffe she | Excel Worksheet Functions |