From: maryam on
Hi dears,
I am new member of mathgroups,my outputs in matlab are as complex numbers,I want to know how can I write them into an excel file.
Thanks
Maryam
From: Varun on
"maryam " <maryam_tayefi(a)yahoo.com> wrote in message <ht0c6g$jqe$1(a)fred.mathworks.com>...
> Hi dears,
> I am new member of mathgroups,my outputs in matlab are as complex numbers,I want to know how can I write them into an excel file.
> Thanks
> Maryam

Hey,

store the complex numbers in a matrix and use the 'xlswrite' function.
From: maryam on
"Varun " <var3161(a)yahoo.co.in> wrote in message <ht0cut$8n9$1(a)fred.mathworks.com>...
> "maryam " <maryam_tayefi(a)yahoo.com> wrote in message <ht0c6g$jqe$1(a)fred.mathworks.com>...
> > Hi dears,
> > I am new member of mathgroups,my outputs in matlab are as complex numbers,I want to know how can I write them into an excel file.
> > Thanks
> > Maryam
>
> Hey,
>
> store the complex numbers in a matrix and use the 'xlswrite' function.

Dear Varun,
Many thanks for your reply, I have already stored the data which are complex number in a matrix but xlswrite function writes the real unit in a excel file only and discards the imaginary unit. What can I do to solve this problem?

Thanks,
Maryam
From: TideMan on
On May 19, 10:30 pm, "maryam " <maryam_tay...(a)yahoo.com> wrote:
> "Varun " <var3...(a)yahoo.co.in> wrote in message <ht0cut$8n...(a)fred.mathworks.com>...
> > "maryam " <maryam_tay...(a)yahoo.com> wrote in message <ht0c6g$jq...(a)fred..mathworks.com>...
> > > Hi dears,
> > > I am new member of mathgroups,my outputs in matlab are as complex numbers,I want to know how can I write them into an excel file.  
> > > Thanks
> > > Maryam
>
> > Hey,
>
> > store the complex numbers in a matrix and use the 'xlswrite' function.
>
> Dear Varun,
> Many thanks for your reply, I have already stored the data which are complex number in a matrix but xlswrite function writes the real unit in a excel file only and discards the imaginary unit. What can I do to solve this problem?
>
> Thanks,
> Maryam

I wasn't aware that Excel could handle complex numbers.
What version are you using?
From: Varun on
"maryam " <maryam_tayefi(a)yahoo.com> wrote in message <ht0ek2$p0s$1(a)fred.mathworks.com>...
> "Varun " <var3161(a)yahoo.co.in> wrote in message <ht0cut$8n9$1(a)fred.mathworks.com>...
> > "maryam " <maryam_tayefi(a)yahoo.com> wrote in message <ht0c6g$jqe$1(a)fred.mathworks.com>...
> > > Hi dears,
> > > I am new member of mathgroups,my outputs in matlab are as complex numbers,I want to know how can I write them into an excel file.
> > > Thanks
> > > Maryam
> >
> > Hey,
> >
> > store the complex numbers in a matrix and use the 'xlswrite' function.
>
> Dear Varun,
> Many thanks for your reply, I have already stored the data which are complex number in a matrix but xlswrite function writes the real unit in a excel file only and discards the imaginary unit. What can I do to solve this problem?
>
> Thanks,
> Maryam

Hey Maryam,

just convert all the complex numbers in the matrix to string using 'num2str' and then use 'xlswrite'. I think that should work.

Regards,
Varun