Q: Simpliest way to use Excel file?
I would like to take a set of records each defined as simple structs of strings (the fields), and put them into an Excel spreadsheet, where each one row in the Excel spreadsheet will correspond to one record.
I am using Visual C++ 5.0 (standard ed.). I know C/C++, and have limited experience with the Win32 API.
The simpliest description of what I need to figure out how to do is (I hope):
1. create a file containing a simple spreadsheet
2. add a row containing a set amount of cells (the # of fields)
3. populate the cells with data
4. repeat steps 2 & 3 an indeterminate number of times
Can anyone suggest a resource detailing the simpliest way to do this and (not necessarily) anything beyond this?
As recommended I have tried reading Microsoft's "OLE DB programmer's reference", but was completely lost. I do not understand what COM or OLE is, and have no real experience with MFC (though I do have a large book explaining the latter). My second question then is, can I accomplish my task without investing an incredible amount of time learning about COM or OLE? Perhaps there is a simple set of C functions in an SDK somewhere to do what I need?
Thanks in advance for any advice,