SAÍDA FORMATADA DE C++ PARA EXCEL

[guipborges]

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.

C++ Syntax (Toggle Plain Text)
#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??