Re: Nan and write on excel "65535"

[shivax]

i miss to write a global variable…

i repeat code complete (before you must to create folder c:\TEST)

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


nomeFileExcel="c:/test/test.xlsx"
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);   



here output:

https://gyazo.com/ce9f9d8b29c00b0a916db26723034ddf



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