ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to auto generate an excel format file contains formula using C (https://www.excelbanter.com/excel-programming/384478-how-auto-generate-excel-format-file-contains-formula-using-c.html)

Celiu

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


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com