It's bettter to save excel sheet in csv format (industry standard), you can use string functions then, or use it as input data for a database (there is odbc library in dev-c++). It doesn't make much sense to write a program what reads data in excel format, there are so many versions of it that I didn't yet see a single program what can read all excel files.
Hi,
Is it possible to write a source code to open an excel file & search for a particular column? i want to extract data from that column.
Try saving the Excel file in TXT format, is easier to scan.
It's bettter to save excel sheet in csv format (industry standard), you can use string functions then, or use it as input data for a database (there is odbc library in dev-c++). It doesn't make much sense to write a program what reads data in excel format, there are so many versions of it that I didn't yet see a single program what can read all excel files.
Simple spreadsheet program what loads and saves in csv format:
http://sourceforge.net/projects/tkorrovi