open an excel file in C++

[rekhamanoj]

kindly let me know how to open an excel file in c++

[Comatose]

Since you didn't really specify....

#include <fstream>

using namespace std;

int main(int argc, char **argv)
{
     fstream fin;
     std::string excel_file = "c:\myfile.xls";
     fin.open(excel_file.c_str(), ios::in);

     if (fin.is_open()) {
          // excel file is opened
          fin.close();
     } else {
         cout << "Failed To Open File" << endl;
     }
}

Although, I bet you are really looking for this here.

[rekhamanoj]

Thank you so much for your quick reply. Can you please let me know how to read data from and write data to the excel file

[Sky Diploma]

Well Xls files are written in BIFF format. therefore i think that we should read them in hexadecimal and then convert them into ASCII.

If it is possible for you to edit the excel file i think you should store it into ".csv" extention.

CSV stands for Comma Separated Values and would be easier to read from.

[kbshibukumar]

Please refer to this link. It may be helpful.

http://www.codeproject.com/KB/database/cspreadsheet.aspx

[Prakash.sit]

plese help the how to read the excel data using pure c++ code