read excel column from c++

Question

0.00/5 (No votes)

See more:

Hi,
Can anyone help me with a sample code?
I'm writing a program which will open word or excel file upon user's selection.
I need to read column by colum and write it to a structure,
do some parsing and calculation in the structure, and then write the whole
structure back to excel.

Thanks

Posted 3-Aug-12 11:56am

tck82456

Add a Solution

Comments

[no name] 3-Aug-12 17:59pm

And you think that someone here is going to write this code for you?

3 solutions

Solution 1

The codeproject site is actually amazing tool, just search and you will find something interesting, like this:
Accessing Excel Spreadsheets via C++[^]

Posted 3-Aug-12 12:21pm

Kenneth Haugland

Solution 3

Hey I work with similar programs I read excel files, in a .csv (comma seperated values)format and this a piece of code:

C++

Function1()
  {
//This function opens the input file,That is the file which has to be read.   
  CString m_fname;
    CFileDialog dlg(true, NULL, _T("*.csv"), NULL,  false, NULL);
    dlg.m_ofn.lpstrTitle      = _T("Select data file");
    dlg.m_ofn.lpstrFilter     = _T("Npd Files  (*.npd)\0*.npd\0CSVFiles(*.csv)\0*.csv\0All Files\0*.*\0\0");      
  
    dlg.m_ofn.lpstrInitialDir = m_fname; /
    
    if (dlg.DoModal() == IDOK)
    {
      m_fname = dlg.GetPathName();
      function2(m_fname);
    }

}
___________________________________________________________________________
//Open the output file where you want to save your processed values
Function1()
  {
  CStdioFile csf;
  CStdioFile outFile;
  CString    buffer;
  CString outDir;

  CEvoFileDlg flDlg(EVODLG_SAVE, outDir, _T("*.txt"));
  flDlg.SetTitle(_T("Select Report File"));
  flDlg.SetFilter(_T("Text File (*.txt)|*.txt|All Files (*.*)|*.*||"));

  if (flDlg.ShowModal() != IDOK)
    return;

  // Open output file
  CStdioFile out;

  if (!out.Open(dlg.GetPathName(), CFile::typeText | CFile::modeCreate |    CFile::modeWrite | CFile::shareDenyWrite))
  {
    Evo::Alarm(23, ALM_NOTIFY, _T("Unable to open file: %s"), m_outDir);
    return;
  }
  double val1, val2;

  if (csf.Open(fname, CFile::modeRead))
  {
    while (csf.ReadString(buffer) )
    {   
      //read the file
      out = swscanf_s(buffer,_T("%f,%f" ), val1, val2);
      //Your calculations here
      //now write into the chosen file.
      out.WriteString(your function that returns a string of values)
    }
 
    csf.close();
  }
}

Hope this helps

Posted 14-Aug-12 1:38am

Sumal.V

Comments

Member 13689404 22-Feb-18 18:28pm

The format of CSV and .xls is different.I am searching for xls.Could you plz let me know xls reading

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)

Volynsky Alex · Accepted Answer · 2012-08-04T00:50:00

You could use a .csv file - which is comma seperated values.
Each cell is seperated with a comma, and each row is ended with a CR ( endl).
Here is a simple example:

C++

#include <iostream>
#include <fstream>


using namespace std;


int main(int args, char * argv[])
{
ofstream MyExcelFile;
MyExcelFile.open("C:\\test.csv");

MyExcelFile << "First Name, Last Name, Middle Initial" << endl;
MyExcelFile << "Michael, Jackson, B." << endl;
MyExcelFile.close();
return 0;
}

Also you can use the excellent articles discussing in detail your question :

A brief introduction to C++ and Interfacing with Excel
http://www.maths.manchester.ac.uk/~ahazel/EXCEL_C++.pdf[^]

How To Use MFC to Automate Excel and Navigate Worksheets
http://support.microsoft.com/default.aspx?scid=kb;en-us;178782[^]

A Very Easy to Use Excel XML Import-Export Library
A Very Easy to Use Excel XML Import-Export Library[^]
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet[^]

Microsoft Excel Automation Class
http://www.codeguru.com/cpp/data/mfc_database/microsoftexcel/article.php/c11745/Microsoft-Excel-Automation-Class.htm[^]