 |  |  |  |  |  |  |  |
How to Read Excel File
Please support our C++ advertiser: Intel Parallel Studio Home
 |
I'm creating a program in Visual C++ and the program I'm creating needs to read a data in an Excel document. It was saved in .xls format.
Can someone help me on how to read data in an Excel file. No need for writing or editing the excel document, just a read function. I found lots of codes on how to manipulate an excel file but it seems too complicated for me since I'm just a noob in C++. Maybe a very simple sample code on how to read from an Excel file.
Can someone help me on how to read data in an Excel file. No need for writing or editing the excel document, just a read function. I found lots of codes on how to manipulate an excel file but it seems too complicated for me since I'm just a noob in C++. Maybe a very simple sample code on how to read from an Excel file.
•
•
Join Date: Apr 2008
Posts: 670
Reputation: 
Solved Threads: 113
Practically a Master Poster
It's not as easy as it sounds, since there is alot of information in an xls file, ofcourse there are different versions too. http://sc.openoffice.org/excelfileformat.pdf
Normally when you are a beginner looking at something like this, you would use CSV files, as they are much easier to read etc. Please note, we will not provide code solutions for you, you will need to do some work yourself and show evidence of the fact you have done so.
Chris
Normally when you are a beginner looking at something like this, you would use CSV files, as they are much easier to read etc. Please note, we will not provide code solutions for you, you will need to do some work yourself and show evidence of the fact you have done so.
Chris
Last edited by Freaky_Chris; Mar 11th, 2009 at 6:22 am.
Knowledge is power -- But experience is everything
•
•
Join Date: Apr 2008
Posts: 670
Reputation:
Solved Threads: 113
Practically a Master Poster
•
•
•
•
Originally Posted by Freaky_Chris 
Please note, we will not provide code solutions for you, you will need to do some work yourself and show evidence of the fact you have done so.
It can get a bit more advanced but to start with it's simple enough, and I'm sure if you do some research; it would be even easier.
Chris
Knowledge is power -- But experience is everything
You can try 3rd party commercial library for this task, for example: http://www.libxl.com. It has an easy interface.
•
•
Join Date: Feb 2009
Posts: 1,968
Reputation: 
Solved Threads: 214
If you want to write to Excel files you can use xlsLib
However I would recommend to use CSV-files (as already mentioned) because they're more C++ friendly and it's just easier to read out the data using some simple file handling techniques ...
However I would recommend to use CSV-files (as already mentioned) because they're more C++ friendly and it's just easier to read out the data using some simple file handling techniques ...
Last edited by tux4life; Apr 10th, 2009 at 9:03 am.
"Never argue with idiots, they just drag you down to their level and then beat you with experience."
|
Similar Threads
- Help to read the excel file. (ASP.NET)
- how read from a excel file using vb6 (Visual Basic 4 / 5 / 6)
- excel file upload problem (ASP.NET)
- Create modify insert del read from excel file (C++)
- Manipulate Excel file using C++?? (C++)
- Read MS-Excel file through EVC++ 4.0 (C++)
- Open Excel file from Visual Basic (Visual Basic 4 / 5 / 6)
- read excel records in asp not refreshing (is the excel file cached) (ASP)
- Reading Excel File using JAVA (Java)
Other Threads in the C++ Forum
- Previous Thread: Header and Cpp file relations in wxWidgets
- Next Thread: Help with if statement and output
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C++ Posts
- Today's Posts
- Unanswered Threads
api array based binary c++ c/c++ calculator char char* class classes code coding compile console conversion count database delete deploy desktop developer directshow dll download dynamic dynamiccharacterarray email encryption error file forms fstream function functions game givemetehcodez google graph gui homeworkhelp iamthwee ifstream input int integer java lib linkedlist linker linux list loop looping loops map math matrix memory multiple news number numbertoword output pointer problem program programming project python random read recursion recursive reference return rpg sorting string strings struct temperature template templates test text text-file tree unix url variable vector video visual visualstudio win32 windows winsock wordfrequency wxwidgets
