I wish to create an Excel spreadsheet at runtime and transfer data into the spreadsheet.
I have no idea how to do this, Any help welcome.
Regards Mark
Printable View
I wish to create an Excel spreadsheet at runtime and transfer data into the spreadsheet.
I have no idea how to do this, Any help welcome.
Regards Mark
Hi,
Think COM.
There is an example on this site on how to do that. It's in the Misc section.
I stumbled through it my own way as well. Here are some hints...
In my experience, if you have larges amounts of data to pass to excel, COM is SLOW. (probably my lack of COM knowledge). If you want to transfer straight data (numbers), and a lot of them, I would suggest writing it first to a text, .csv file. Then when you are done, use COM to open the .csv file into XL, and re-save it as a .xls file.
If you don't use the #import directive, but use ClassWiz to create classes for you from excel8.olb, you can write your own functions. For example, there wasn't a SaveAs with the arguments I wanted, so I wrote my own. I just based it on the functions ClassWiz makes. Again, my lack of COM knowledge might be showing. You might be able to do this with the #import directive, I'm not sure.... (COM is next on my list of things to learn).
HTH,
Harvey Hawes
Software Engineer
BioScience Analysis Software Ltd.
Masters Candidate
Cardiovascular/Respiratory Sciences
Faculty of Medicine
University of Calgary
Calgary, Alberta, Canada