I've got a C-file, and I'd like to generate an Excel worksheet with some content and some graphs.
Got any ideas on how I proceed? Do I translate to C++?
Thanks :-)
Torbjørn
I've got a C-file, and I'd like to generate an Excel worksheet with some content and some graphs.
Got any ideas on how I proceed? Do I translate to C++?
Thanks :-)
Torbjørn
Hey,
You can use a .csv file, their format is pretty easy and you can just write it out from your proggy, however you can only use data in these, not graphs as you mentioned, you should play around with excel and save some sheets as .csv and look at the format you will see that not everything is supported like formulas which may be a problem, but it will be alot harder if you wanna start making graphs from your program.
Hope that helps,
TNT
TNT
You Can Stop Me, But You Cant Stop Us All
If you used C++ and MFC you could use your app as an automation client for excel and automate excel to enter data and make graphs. It's relatively easy to do with MFC, and there are some good tutorials in the MS knowledge base, as excel is also a very powerful automation server anything you can do from excel itself can be done by automating it.
The disadvantages are you would need to have excel installed on any PC you ran the app on, and automation creates quite a lot of overhead.
It is possible to use automation without MFC but its much harder, as you would need to understand COM and be able to obtain and use excel interfaces from it.
Thanks, guys!
I think I'll switch to Visual Basic, though!