Prev: While a simulation is running, block parameters?
Next: Error concerning optimset
From: Fraser Dickson on 8 Mar 2010 09:01
Hi im trying to use the xlswrite command to create a excel document from my array which is all complex numbers

the numbers are not shoiwng up in the correct format on excel ( i have no idea what format they are being shown in ! ) is there anything special you need to do when using xlswrite with complex numbers. They are defienetley in the correct format on Matlabs side

im just using

xlswrite(filename,matrix_a)
From: ade77 on 8 Mar 2010 12:16
"Fraser Dickson" <fraser.dickson(a)gmail.com> wrote in message <hn2vvm$pgf$1(a)fred.mathworks.com>...
> Hi im trying to use the xlswrite command to create a excel document from my array which is all complex numbers
>
> the numbers are not shoiwng up in the correct format on excel ( i have no idea what format they are being shown in ! ) is there anything special you need to do when using xlswrite with complex numbers. They are defienetley in the correct format on Matlabs side
>
> im just using
>
> xlswrite(filename,matrix_a)

Fraser,
you can use cell array to do it.
For example:

a =
3 + 4i
5 - 4i
8+ 5i
2 - 7i
2+ 6i

a_str = num2str(a);
a_cell = cellstr(a_str);

xlswrite('yourfile', a_cell);
 | 
Pages: 1
Prev: While a simulation is running, block parameters?
Next: Error concerning optimset