• C

Accessing Xls File


 hi guys i hope u ok now

   i want to access first coloum in .Xls Excel  file using C compiler

                any one here can help me ?
                     
                 
                                                                     Thanx
BinLadinAsked:
Who is Participating?
 
ankuratvbCommented:
0
 
ankuratvbCommented:
What compiler are you using?
0
 
grg99Commented:
It's not very easy.  The .xls file format is rather blowsy.  Do a google search for "xls file format".  Notice there are at least 5 different versions of the xls format.  Note that the info is very very very sparsely arranged.   Note that it takes about 300 lines of careful C code to even begin parsing the data.

You can do it a bit easier with DDE commands to Excel, but this way is quite slow and you have to have Excel on the machine, open and running.    

Perhaps a better way is to export the .xls file to a comma or tab delimited file.  Then the file is EASY to read with your basic fscanf().

0
Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

 
avizitCommented:
If you are okay with using other language for it , I would suggets perl for it
perl has many modules which lets you access excel files

http://search.cpan.org/search?query=excel&mode=all

/abhijit/
0
 
anupvijayCommented:
Another way is to write a VB dll with interfaces accessible from C. I suggest this because it is easier to manipulate office
documents in VB.
But then interoperability of VB and C is a RISK that you have to take :-). But it is an option.

Cheers.
0
 
anupvijayCommented:
BinLadin
Sorry for jumping the gun earlier......but what exactly did you mean by accessing .xls from C 'compiler' ?

Cheers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.