Though I do have some previous programming experience I am very new to C++. I have been through some online tutorials and all of the concepts are now familiar to me. I now have a project that I want to work on in order to consolidate my knowledge further but am unsure as to even read in the data to begin with. I started by setting up a series of excel files containing the data I want to work with. I presumed this would be the easiest way of going about it but after some research on the internet have found that maybe it isn't. I know this is a very simple thing to do but would just like some advice and tips on how other people go about it.
Excel files, as in ".xls" and ".xlsx" are NOT single files. Make a brand new Excel file, don't put in any data and change the extension from ".xls" or ".xlsx" to ".zip" to see what I mean.
The easiest way to do this is to start with a text file. As in ".txt" not ".doc".
EDIT: If for some reason you HAVE to work with Excel files specifically then I would recommend looking into VBScript, to do it in C++ check out http://www.msdn.com for information on how to do this.
RE-EDIT: What I said about Excel files also applies to Open Office Calc files.