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??