I have my data in an excel file which has 2 columns and about250 rows. i want to read this file in C++ and want to store the data in a 2D array having 2 columns and 250 rows.Please solve the problem as soon as posssible as i am in a great need.mail me at swati_npl_ors[at]yahoo[dot]co[dot]in

Senior members may not reply to this thread if you:

• used "Please help", "C problem" or something equally vague as the title for your thread.
• included example code in your message and not use the syntax highlighting [c] tags.
• did not describe the problem accurately or include the error message (if any).

The guidelines for posting can be found here.

We encourage you to post again once you've done that.

__________________
Please read these Guidelines before posting on the forum

"A person who never made a mistake never tried anything new."
Einstein

Hi swati_npl

Do you still want a solution to your problem of reading an excel file in C++ (2005)?

Aresti

Still need help with this one.

Investigate "Excel COM". my current favorite, I have not start using Visual Studio Tools for Office.

Hi

At the moment I don't know how to use Excel Com to read and then write to an Excel file, I will investigate that if I can. To write to Excel I used System.Data.OleDb. basically, you access the Excel file as a database. As far as I know, the Excel file also has to look like a database table in each sheet you want to access. I have the code on another thread here, where you can look: (I am programming in C#, so I'm not sure of the difference here).

I can't find the thread right now. Do you want me to mail you the code? You'll have to give me your email address.



If I find the thread I'll edit this post with it.

It's here: Reading an Excel file in C#.

__________________
Custom BB codes you can use here:
[HTML] | [C++] | [CSS] | [JAVA] | [PY] | [VB]