Re: Nan and write on excel "65535"

[shivax]

excuse me

I forgot to mention some features that my code refers to

Try this code:
(Create folder c:\test)


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

pkg load windows
pkg load io

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 ="C1:J33"

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



Output:

https://gyazo.com/66da3e52b9efac41dae12c306930ba31



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