At first writing C++ code for interaction with Excel isnt a beginners task, so be prepared for a lot to learn and some weired stuff like COM.
The basic tasks are importing the Excel interface via a COM dll and using the correct namespace. After that you can access an Excel file in the specified way. Take a look at the article
BasicExcel to learn it.
A tip beside: with C# the interaction with Excel is a lot easier. The reason is, that in C# you are in the .net-runtime which seamlessly use the COM-interface. The article
Excel Reader shows how easy it works. It shows the power of the net-runtime and C#.