Connecting and reading excel file

Question

1.00/5 (1 vote)

See more:

Hi,
How do I fetch data of particular cell of excel file? I don't have any idea about this. also tell me how do I establish connection between mfc and excel file.
Thank you very much in advance.

Posted 26-Apr-11 22:49pm

virus131

Add a Solution

Comments

[no name] 27-Apr-11 5:22am

Hey can you convert xls into csv file to read write. because reading .csv file is much easy than .xls.but if no then i have one solution

2 solutions

Solution 1

It's all described in this Codeproject: Fetching Data from Microsoft Excel using SQL[^]

Good luck!

Posted 26-Apr-11 22:54pm

Jeffrey Enzo

Comments

virus131 27-Apr-11 5:10am

Thanks for replying. But I need solution in mfc.

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)

santosh dhanawade · Accepted Answer · 2011-04-26T23:25:00

Solution 2

This link may help you
Reading Excel files using ODBC in mfc[^]
this link provide you a project of code if you have any doubt then reply

Posted 26-Apr-11 23:25pm

santosh dhanawade

Comments

virus131 27-Apr-11 5:40am

Thanks a lot for your reply. I've already tried this one. but there is 1 problem- whenever user changes excel file, each time it needs to define a new table for the updated data & again need to change table name in sql statement of program also. this is not user friendly approach. Please help me if possible.
Thanks again.

[no name] 27-Apr-11 5:51am

Then Take excel file name from user
like
FileName="MyExel.xls";
sSql = "SELECT * FROM "
+FileName+
"ORDER BY field_1";

In give project link

virus131 27-Apr-11 6:09am

no, it's not working. It still needs to name a section of data in the excel sheet using "Insert->Names" which I don't want to do. Please suggest another solution.

virus131 27-Apr-11 6:24am

Hey, Its done by using-
sSql = "SELECT * FROM [sheet1$]"
"ORDER BY field_1";

[no name] 27-Apr-11 7:32am

Thats nice some time we have solutions but we doesn't identify it.