reading microsoft excel file using c

[prasun]

hi guys...
can anyone of u ans me how to read a microsoft excel file using c.....
if possibel give the lines of code..

[gpraghuram]

hi guys...
can anyone of u ans me how to read a microsoft excel file using c.....
if possibel give the lines of code..

Idea which i have is, you can save the excel file as a csv file and after that reading the file file will be a normat file read.

i think there are some existing threads in this forum which was requesting the same information.
Please do a search to get the info in this forum.

Raghuram

[weaknessforcats]

Also, check the Office SDK.

I suspect you will need to use COM for this.

[prasun]

well i have to read a .xls format of excel files not the .csv format......
so if u people could reply wid a cod that wud be really helpfull

[DeMan]

Interpreting an xls file will probably be a very, very (did I miss a very), difficult task. MS has it's own way(s) of storing data , and you should first see how much you can find about how and why they do that -> I'd imagine no easy feat....they do things their own way for a reason).
I don't believe there is a simple way to do this, and while the experts are willing to help you work through specific problems you may be having, I can't imagine too many of them doing the whole project for you.....

Is there a particular reason why you need to interpret the xls file? The earlier suggestion of using a csv (or comma seperated vector (or value?) I think){which excel supports} is probably your easiest option......

[archonmagnus]

You'd probably need to start off by reading the Microsoft Excel File Structure documentation that has been compiled by OpenOffice.Org. Most of the data in an excel file are "non-printable" characters. There is actually quite a bit of data to parse through as well. IIRC, a blank excel .xls file is still ~13.5 KB.