writing a c++ program using excel to get data from

Question

0.00/5 (No votes)

See more:

I have a big excel sheet that has dealer names, addresses, phone numbers, contacts I want to be able to have the user enter a state into c++ and then have it look into excel and then output those dealers name, address, phone number. Is this possible to do and how would I go about doing that? I am new to c++ so any help would be wonderful.

Posted 11-Feb-11 10:55am

Member 7666290

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yusuf · Answer 1 · 2011-02-11T11:04:00

Solution 1

It is possible to do what you want using C++. You mentioned that you are new to C++, with that in mind I am not sure if this would be easiest project to start with. If you have a choice, look for some of the .NET languages either C# or VB.NET. You will find the interoperability to be much easier.

If you want to stay with C++, there are a number of articles here in CP. For starters look at BasicExcel - A Class to Read and Write to Microsoft Excel[^] and CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet[^]

If you want to explore more browse here[^]

Posted 11-Feb-11 11:04am

Yusuf

Comments

Member 7666290 11-Feb-11 17:15pm

I have to use c++ for my class it is a little project that we are doing. Thanks

Yusuf 11-Feb-11 17:26pm

Aha! If it for class work, for your own benefit, don't use any code you find until you understand it. You will benefit alot if you follow that simple rule.

Member 7666290 11-Feb-11 17:56pm

Do you have an helpful hints in doing this project? Any help would be appreciated. I need a starting point. Thanks

Yusuf 11-Feb-11 18:03pm

what about the hints I gave above?

Member 7666290 11-Feb-11 18:20pm

would it be easier if I saved my excel file as a cvs and put it into a database like ms access? I find those helpful but still confusing. Or would you have another idea for me to do, our choices are some kind of processing data, automated administrative tasks, webpage link mapping, or network communication. I am not sure which would be easier to do? any thoughts on ideas for this?

Sergey Alexandrovich Kryukov 11-Feb-11 22:29pm

Very reasonable, discussion, too, my 5.
--SA