Outputting Data to Excel Sheet - MFC Application
I have read some of the topics that were posted on a similar topic to mine but would like some specific guidance please.
I have a simulation developed in C++ on VS 2010. Currently, the program produces multiple text file outputs containing data. Each seperate file represents different conditions. There could be anything from 1 to 100 of these text files outputted depending upon how I set it up.
What I normally do, is after I have run the program I gather the data manually in to an excel workbook to analyse the data. This involves importing the data from a text file using 'Fixed Width' setting whereby the fields are arranged in columns with spaces between each field. Each text file contains 2 columns of data.
What I want: is to write all the data (not only to the text files) but also to the same excel worksheet. This will save me a lot of time, not having to manually import each text files data using the Excel import feature.
For each set of data I would require one cell to have a description (kind of like a title to describe the data) and then underneath the 2 columns of data which would have multiple row entries. One blank column space between each different test set would be ideal to make it easier to distinguish them. e.g.) Cell A1 - Description; Cell A2:A26 and B2:B26 would contain data. Column C cells would be blank. Cell D1 - Description; Cell D2:D26 and E2:E26 would contain data. Column F cells would be blank. etc. etc.
The thing is, I have never done anything like this before and I wouldn't know how to or where to begin. Like I said, my code is developed using MFC in C++. If you can provide any ideas or point me in the right direction I would be most grateful?