?
Solved

Accessing Xls File

Posted on 2004-04-25
8
Medium Priority
?
248 Views
Last Modified: 2010-04-15

 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
0
Comment
Question by:BinLadin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 9

Expert Comment

by:ankuratvb
ID: 10911077
What compiler are you using?
0
 
LVL 9

Accepted Solution

by:
ankuratvb earned 1000 total points
ID: 10911183
0
 
LVL 22

Expert Comment

by:grg99
ID: 10911613
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Expert Comment

by:avizit
ID: 10911855
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
 
LVL 2

Expert Comment

by:anupvijay
ID: 10918624
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
 
LVL 2

Expert Comment

by:anupvijay
ID: 10918637
BinLadin
Sorry for jumping the gun earlier......but what exactly did you mean by accessing .xls from C 'compiler' ?

Cheers.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial is posted by Aaron Wojnowski, administrator at SDKExpert.net.  To view more iPhone tutorials, visit www.sdkexpert.net. This is a very simple tutorial on finding the user's current location easily. In this tutorial, you will learn ho…
Summary: This tutorial covers some basics of pointer, pointer arithmetic and function pointer. What is a pointer: A pointer is a variable which holds an address. This address might be address of another variable/address of devices/address of fu…
The goal of this video is to provide viewers with basic examples to understand recursion in the C programming language.
The goal of this video is to provide viewers with basic examples to understand and use switch statements in the C programming language.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question