Using MS Excel in VC++
-
Hi I want to use MS Excell in VC++ program for recording and plotting data. Should I use CRecordSet Class or else. If yes, can I have some example program for it? Regards
As far as I know, the CRecordset class is used when you are working with databases. In your case, you have to use Excell automation, search on CP and google for it and you'll find a lot of tutorials.
QSMZ wrote:
I want to use MS Excell in VC++ program for recording and plotting data.
You mean that your program should create an excell file and write data in it then create a chart in the excell file ? If yes, I think this should be feasible through automation.
Cédric Moonen Software developer
Charting control [v3.0] OpenGL game tutorial in C++ -
Hi I want to use MS Excell in VC++ program for recording and plotting data. Should I use CRecordSet Class or else. If yes, can I have some example program for it? Regards
QSMZ wrote:
I want to use MS Excell in VC++ program for recording and plotting data.
I'm not really clear on what you mean. Perhaps you would benefit from writing a DLL that you use from Excel for "data recording" depending on the where you get the "data" from. If you only want Excel for presentation reasons you may record and plot the data in your own application, but save it to an Excel file and draw charts in it using automation as Cédric said. I've done this about five years ago, but unfortunately that means I don't have any source code to give away and I've forgotten the details. However, it's not really that hard, just search for Excel and automation and you'll get a lot of useful results. One tip I remember though, use multidimensional safearrays for writing the data into the Excel sheet if you have a lot of data. I had about 10MB and writing it cell by cell took about 40 minutes. Using a multidimensional safearray it only took a couple of seconds.
"It's supposed to be hard, otherwise anybody could do it!" - selfquote
"High speed never compensates for wrong direction!" - unknown -
Hi I want to use MS Excell in VC++ program for recording and plotting data. Should I use CRecordSet Class or else. If yes, can I have some example program for it? Regards
search BasicExcel on codeproject
-
Hi I want to use MS Excell in VC++ program for recording and plotting data. Should I use CRecordSet Class or else. If yes, can I have some example program for it? Regards
A Simple search of code project yields a number of jewels. ^[] there are a lot of things to consider when you begin trying to use windows office automation not the least of which C++ isn't the "best choice". VB ultimately is a much better choice for this type of task(native language for excel). Also for deployment will the target users all have office? will they have the "right" version of office? Do you really need to write a full blown app or will VB scripting do the job? Excel objects are setup just like the in the program books, pages, range and cell.