Guipborges 0 Newbie Poster

Hi everybody.
I have a simple problem. Need send the c++ output to excel(csv->xls or xls direct) in formated data. I can send the data to excel, but i can´t format that like this:

|_ col 1__|___col 2___|___col n____|
row 1......|....2row 1
row 2......|....2row 2
row 3......|... 2row n

What i can´t, is go to begin in col 2. My code put the data in this way.


|_ col 1__|___col 2___|___col n____|

row 1
row 2
row n
2row1
2row2
2rown

I don´t set this pointer to next columns.
If i put the data in the same "for", i can put the data in way i need. Else, i do not.
But, the column 2, have a leght biger then column 1, and I need 2 "for" to put the data.
Follow the code.

#include <iostream>
#include <iomanip>
#include <fstream>
#include <string>
#include <cstdlib>
#include <stdlib.h>

using namespace std;


class DATA
{
  public:
    int dados[5];
    int dados2[7];

};

int main()
{

   DATA c;

    for (int i = 0; i < 5; ++i)
    {
        c.dados[i]= i;
    }
   for (int i = 0; i < 7; ++i)
    {
        c.dados2[i]= i;
    }


    ofstream out;
    out.open("data.txt");

     out << "DADOS 1"<<",";

    for (int i = 0; i < 5; ++i)
    {
    out  << c.dados[i] <<",";
    }out<<"\n";

     out << "DADOS 2"<<",";

    for (int i = 0; i < 7; ++i)
    {
    out  <<  c.dados2[i] <<",";
    }out<<"\n";


    system("RELATORIO.xlsx"); //open excel and import a data.txt to format xls


    return EXIT_SUCCESS;
}

this code put the data in rows, like a

|__DATA_1_|__1__|___2__|___3___|__4____|___5____|___N_____|
|__DATA_2_|__1__|___2__|___3___|___4___|___5____|___N_____|

this is the way I found to get my data, but is not the way I want

Any help??

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.