Neewbie Excel problem
Hi guys..
I'm fairly new in C++ and still trying to grasp some of the basics.
I am using a C++ Builder and my question is...how do I connect to Excel worksheet using C++, ADO or ODBC?how do I do this?
Any pointers would be greatly appreciated..
Thnks guys.
I'm pretty sure a board search for "excel" will turn something up
If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
If at first you don't succeed, try writing your phone number on the exam paper.
To connect to a worksheet or use ADO you need COM programming experience.
For ODBC, you need experience with the ODBC API and probably a bit a bit of WinAPI.
All of this is fairly intermediate stuff. I'd keep up the work on the basics first if I were you.
You can use ios::bin or ios::binary in fstream but you would have to know the format of excel
Child who knows C++Using Borland C/C++ Compiler 5.5 (Command Line Version)
Actually that's not a good idea. For future reference, you can get file formats at wotsit.org.
If Kawia has not yet mastered the basics, let alone how to use APIs, there's really no point in learning binary file i/o. By the time he gets to that point he probably will have the skill to learn the aforementioned APIs anyway.
My advice to kawia is to just keep learning C++, read a couple of books, etc... and when you're comfortable with most of the features of C++, take a look at some of these APIs.
I don't have the skill to learn APIs and I know binary file i/o. I think it's simple, but; whatever!
Child who knows C++Using Borland C/C++ Compiler 5.5 (Command Line Version)
Well there really is no difference between learning an API and learning iostreams. One's standard (or was) and one's not. That's it. Doing binary file i/o on a commercial file is a ridiculous idea when there's a fairly high-level API right in front of you.
From the question;
>>connect to Excel worksheet
I think he's talking about using excel properly (via COM automation - not the lame old trick of creating a CSV file
I want to connect to excel worksheet/sheets using ADO and read a file, not converting the file to text .
Thanks.
Honestly, if your a newb it's a bit too much of a job.Originally Posted by kawia
Just to satisfy your curiosity, heres a working example in VC++ of how to use ADO to read from an excel sheet.
