writing data to excel problem

New comment
 

I am trying to write data to excel and no errors arise when I compile but If I have a loop


I my function is supposed to open the file to write initialized as such

string filename=StringConcatenate("Quantitative_Info",Symbol(),"_",timeperiod,".csv");
    int handle=FileOpen(filename,FILE_CSV|FILE_WRITE,',');

I am trying to use a loop to save me coding time which is

for(i = 0; i < 12; i++)
    {   
       FileWrite(handle,months[i],DoubleToStr(pipsaverage[j][i][0],1),DoubleToStr(pipsaverage[j][i][1],1),DoubleToStr(pipsaverage[j][i][2],1),DoubleToStr(pipsaverage[j][i][3],1),DoubleToStr(pipsaverage[j][i][4],1),DoubleToStr(pipsaverage[j][i][5],1),DoubleToStr(pipsaverage[j][i][6],1),DoubleToStr(pipsaverage[j][i][7],1),DoubleToStr(pipsaverage[j][i][8],1),DoubleToStr(pipsaverage[j][i][9],1),DoubleToStr(pipsaverage[j][i][10],1),DoubleToStr(pipsaverage[j][i][11],1),DoubleToStr(pipsaverage[j][i][12],1),DoubleToStr(pipsaverage[j][i][13],1),DoubleToStr(pipsaverage[j][i][14],1),DoubleToStr(pipsaverage[j][i][15],1),DoubleToStr(pipsaverage[j][i][16],1),DoubleToStr(pipsaverage[j][i][17],1),DoubleToStr(pipsaverage[j][i][18],1),DoubleToStr(pipsaverage[j][i][19],1),DoubleToStr(pipsaverage[j][i][20],1),DoubleToStr(pipsaverage[j][i][21],1),DoubleToStr(pipsaverage[j][i][22],1),DoubleToStr(pipsaverage[j][i][23],1));
       FileWrite(handle,"std deviation",DoubleToStr(pipstdev[j][i][0],1),DoubleToStr(pipstdev[j][i][1],1),DoubleToStr(pipstdev[j][i][2],1),DoubleToStr(pipstdev[j][i][3],1),DoubleToStr(pipstdev[j][i][4],1),DoubleToStr(pipstdev[j][i][5],1),DoubleToStr(pipstdev[j][i][6],1),DoubleToStr(pipstdev[j][i][7],1),DoubleToStr(pipstdev[j][i][8],1),DoubleToStr(pipstdev[j][i][9],1),DoubleToStr(pipstdev[j][i][10],1),DoubleToStr(pipstdev[j][i][11],1),DoubleToStr(pipstdev[j][i][12],1),DoubleToStr(pipstdev[j][i][13],1),DoubleToStr(pipstdev[j][i][14],1),DoubleToStr(pipstdev[j][i][15],1),DoubleToStr(pipstdev[j][i][16],1),DoubleToStr(pipstdev[j][i][17],1),DoubleToStr(pipstdev[j][i][18],1),DoubleToStr(pipstdev[j][i][19],1),DoubleToStr(pipstdev[j][i][20],1),DoubleToStr(pipstdev[j][i][21],1),DoubleToStr(pipstdev[j][i][22],1),DoubleToStr(pipstdev[j][i][23],1));
    }

nothing writes to the excel sheet. If I were to take it out the loop and code it line by line then it would write to excel sheet.

thoughts?

 
You need to read the documentation properly . . . FileOpen
 
RaptorUK:
You need to read the documentation properly . . . FileOpen

I read it and I dont get any error messages. If I do without the loop, It produces a csv sheet with the information I want. If I use the loop it will create a sheet and it will write to the sheet except for what the loop is supposed to write.
 
Don't use FILE_WRITE only, use FILE_READ|FILE_WRITE.
FileOpen(filename,FILE_CSV|FILE_READ|FILE_WRITE,',');
 
jeemba2012:

I read it
No . . . if you did you didn't read it properly or didn't understand it . . . . qjol read it as you can see.
 
RaptorUK:
No . . . if you did you didn't read it properly or didn't understand it . . . . qjol read it as you can see.
o, thanks ;-)
New comment
Reason: