Re: Nan and write on excel "65535"

[shivax]

in case of problem to open file 

here i write the code:


function ret=test_WriteExcel()
  
  global OutputEquity;

strx="Test.xlsx";
 
printf("\n PRINT EQUITY \n");


nomeFileExcel=strcat(OutputEquity,strx);
nomeFoglio="Test";
riga=1;
colonna=1;
deleteFileExcel=true;


 newNomeEquity(1,1)= {"    "};  
 newNomeEquity(2,1)="Data Rilev";
 newNomeEquity(1,2)= NA;  
 newNomeEquity(2,2)="Index Rilev";
 con=0;
 
filtro_Bypass=NA(33,4);
filtro_Bypass
 
 for fr=1:columns(filtro_Bypass)  
con++;
  matrixx(:,con)=filtro_Bypass(:,fr);
  newNomeEquity(1,con+2)=NA; 
  newNomeEquity(2,con+2)="FiltroBYPass";    
con++;  
  matrixx(:,con)=NA;
  newNomeEquity(1,con+2)=NA;   
  newNomeEquity(2,con+2)=NA;  
endfor


if deleteFileExcel
      delete(nomeFileExcel);
      endif



strCompletaNum=TitanTrovaStringExcel(riga,colonna+2,rows(matrixx),columns(matrixx));

nomeFileExcel
rstatus=xlswrite(nomeFileExcel,matrixx,nomeFoglio,strCompletaNum);  




--
Sent from: http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html