reading from Excell

[mrjoli021]

I have an Excell file that I need to read to be able to bring the cells into a struct. I have tried using fstream and I get garbage. How can i go about this??

[Infarction]

Excel uses a proprietary format. Unless you know how to decode it, you won't be able to get very far. You might try exporting the excel file as a CSV or something...

[John A]

If you're feeling adventurous, download OpenOffice's source code. It contains algorithms for reading Excel files, which you can implement in your program, under the GPL.

And if you don't like the idea of digging through mountains of source code, do what Infarction suggested, and try reading in a simple ASCII text file instead.

[mrjoli021]

I found a third party util that will export the excell into cvs format. Now I am not that familiar with two dimension arrays. I have the cvs file with 3 rows and 20 colums. I also have two colums as strings and 1 as an int.

Thanks,

[Infarction]

So your problem now is...?

[mrjoli021]

I dont know the systax for the two dimensional arrays.

[John A]

If you don't know how to handle 2d arrays, I'd say perhaps you aren't ready for reading in files.You should go back and study some more C/C++ until you at the very least have a solid understanding of arrays and how they work.

[Aia]

I dont know the systax for the two dimensional arrays.

two dimensional array is a funcy way of say an array of arrays, and you will declare it pretty much like a regular array.

example:

char  array[3]; /* This is an array of 4 elements */
char  array[2] [3]; /* These are three arrays that each one has 4 elements*/

Last one is a 2D array of type char.

>I found a third party util that will export the excell into cvs format

Gee, I wonder why you didn't just go to:

File > save as > .csv