By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,677 Members | 1,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,677 IT Pros & Developers. It's quick & easy.

reading microsoft excel file using c

P: 2
hi guys...
can anyone of u ans me how to read a microsoft excel file using c.....
if possibel give the lines of code..
Jun 25 '07 #1
Share this Question
Share on Google+
5 Replies


gpraghuram
Expert 100+
P: 1,275
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
Jun 25 '07 #2

weaknessforcats
Expert Mod 5K+
P: 9,197
Also, check the Office SDK.

I suspect you will need to use COM for this.
Jun 25 '07 #3

P: 2
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
Jun 28 '07 #4

DeMan
100+
P: 1,806
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......
Jun 28 '07 #5

archonmagnus
100+
P: 113
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.
Jun 28 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.