You may use different methods to read Excel files. Which one to use depends on the version of the Excel files (XLS and/or XLSX) and if Excel is installed or not:
Using Excel Automation (COM / OLE Dispatch) with the Excel type library. This requires an installed Excel on the machine running your application (which defines what Excel file versions can be read) and the Excel type library on the development machine.
Using ODBC or ADO (OLE DB). These are database interfaces that handle sheets from Excel files like databases tables. Drivers for XLS files are present on all Windows systems. Drivers for XLSX files are installed by Office 2007 or with the 'Microsoft Access Database Engine 2010 Redistributable' package.
Once you have decided which method you want to use, search for samples here at CP and in the web using the above keywords. But be prepared that reading Excel files is not done with a few lines of codes.
Dear coders, for few days, I struggle to solve a simple problem: to scroll the window after zooming, in such a way, that mouse position stay in the exactly same logical position ... and I didn't succeded.
The view is based on CScrollView, mapping mode is always MM_TEXT, zomming is changing by 10%. Nothing special.
Have you see how Window Photo Viewer (from Windows 7) work on zooming ? I want to implement the same behaviour ... does anybody do that before ? Anybody have similar code ?
Is it possible to write precommit hooks for svn in c/c++?
If so how to write a hook which will ask the user to update document version everytime the user checks in the document in svn. My knowledge is limited to the fact that the .exe to be created should be named Precommit and be placed in the repository where the user performs any action in repository.Please guide me.