Thread: Reading Excel

I have problem in reading excel file . I have to read cell wise data and i have to evaluate the data. My file looks like as below

DATE Hectare No. Tag No. Species Size Leaf Flower Fruit
None Flush Mature None Buds Opened None Young Ripe

16.12.99 2 1320 RAND 68 0 0 100 100 0 0 0 100 0
1325 RAND 90 0 0 100 100 0 0 100 0 0
1326 ANOL 88 0 0 100 100 0 0 100 100 0
I have to read data for the given month and i have to read how many individual species are there with 100 as data in leaf(none),leaf(flush),leaf(mature) and so on for flower and fruit...
i have to count the no. of species in each category for the given month.

Maybe it's best to try it yourself first and then post your code.
I'm not sure how good you are in C programming but you can start with opening en closing a file.
There are several ways of reading a file (fgets, fread, fgetc, fscanf).

Check this site for the manual pages...

Excel (.xls) files are in Microsoft's "almost secret" format (you pay $$$ to find out).

The only practical way you will be able to do this is if you export your data into a text file (say a .csv - comma separated values) file. This is just a text file, and is easy to read using standard C features.

Try wotsit.org. They have all the major formats, but like he said earlier, they're ***-TOP SECRET-***

meena....
i think the following method should work...
read the file , into a character array until you encounter a tab (\t)

try sth like this:

char a[25];
int i=0;
while(ch != '\t')
{
fscanf( filename ,"%c",&a[i] );
i++;
}


with this you can read the first cell.
and so on..
i have not try, but this should work..

chandra sekhar