Read/Write a excel file using C program & OS is DOS

[akhitesh]

hello ,
i want to accomplish the following tasks in c/c++ using DOS as OS.

1. create an new excel file in runtime without opening the excel
application

2.reference any particular cell in a particular sheet of the workbook

3. read / write into the chosen cell.

what are the available options ?
Could anyone provide me with a sample code... perhaps a single
function which takes the filename & absolute cell reference as the
parameters in addition to a read/write mode parameter along with the
data item.

thanking in anticipation...

[Fordy]

It will be too difficult to do this in DOS....you can do it in windows via COM....and for this you will probably find it easier in C++

[novacain]

>>1. create an new excel file in runtime without opening the excel
application<<

Easy, use a CSV. Comma seperated volume ie cells are sperated by commas ','. Just save your text file as a .csv, use sprintf()


>>2.reference any particular cell in a particular sheet of the workbook<<

Not as easy.
Have to count the new line characters to find the row and then the commas to find the column.
Load the whole file into a char array and use pointers.

>>3. read / write into the chosen cell.<<

As a CSV is text and could have variable length in a cell, I would not modify the cell on the file but rewrite the whole file.