Read excel data into 2d Array

[ivan1]

Hi all,

I am trying to read data from excel file into my c++ code. I have 2d array and excel file has something like {1,2,3};{1,3,5};{2,3,4};etc. in each row. I have one column and 50 rows. I tried the following code but don't know how to identify the cells:

int main()
{
    ifstream file("C:/Users/text.xlsx");
    
    int p[i][j];
    
       for(int i = 0; i < m; ++i)
           for(int j = 0; j < n; ++j)
          {
       {
        file >> p[i][j];
        
        cout << p[i][j] << ' ';
        }
    }

What can I do to get it worked? Thanks

[tath]

http://stackoverflow.com/questions/5167625/splitting-a-c-stdstring-using-tokens-e-g

there is also strtok from c library ( http://www.cplusplus.com/reference/cstring/strtok/?kw=strtok )

[andywestken]

I though xlsx was a zipped up set of XML files, so I'm not sure how ifstream alone will be a lot of use?

(You will need a zip library and an XML parser, if you want to go it alone, rather than using a library to help you, like LibXL
http://www.libxl.com/ )

Andy

Office Open XML
http://en.wikipedia.org/wiki/Office_Open_XML

Office Open XML (also informally known as OOXML or OpenXML) is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents.

[ivan1]

I created these rows in excel but I can copy it to txt file. Can c++ read this kind of data? Fore example, my first vector is the set of elements {1,2,3}. Can it understand this? Doesn't my code work for this purpose?

[Mila1]

http://www.rasteredge.com/how-to/csharp-imaging/pdf-barcode-reading/

there is also strtok from c library