Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file

[dlsquires]

rcharan51 wrote
> mixed{1, 10}="crctd Y1";
> mixed{1, 11}="crctd Y2";
> mixed{1, 12}="H";
> i=0;
> for(i=[1:634])
>   mixed{i+1, 10}=cy1(i);
>   i=i+1;
> endfor
> i=0;
> for(i=[1:634])
>   mixed{i+1, 11}=cy2(i);
>   i=i+1;
> endfor
> i=0;
> for(i=[1:634])
>   mixed{i+1, 12}=H(i);
>   i=i+1;
> endfor
> xlswrite('crctn.xlsx', mixed, 'First_sheet');
> 
> [...]
> 
> Is there any wrong with my code I havent installed java package **octave
> 3.8.1 | windows 8.1 |io 2.2.2***

I ran your code ( added cy1 = ones(1,634); cy2 = ones(1,634)*2; H = 1:634;
), and I was able to open the resulting file in OpenOffice 4.1.0

I am on Windows 7 with MXE Octave 3.8.1, io 2.2.2 and java 1.2.9 loaded.




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Problem-when-writing-a-cell-array-char-and-numeric-data-to-excel-xlsx-file-tp4664851p4664858.html
Sent from the Octave - General mailing list archive at Nabble.com.