Prev: power spectral density
Next: lsqnonlin, badly scaled matrix
From: Anna L-N on 25 Apr 2010 16:38
Hello,

I have 2 excel files which have to be imported into Matlab, however, one file is not imported fully, only one part of it, even though in open office document the file looks intact. Does anybody know why that is the case?

Thank you.
Anna
From: us on 25 Apr 2010 17:20
"Anna L-N" <s0793217(a)sms.ed.ac.uk> wrote in message <hr297a$84m$1(a)fred.mathworks.com>...
> Hello,
>
> I have 2 excel files which have to be imported into Matlab, however, one file is not imported fully, only one part of it, even though in open office document the file looks intact. Does anybody know why that is the case?
>
> Thank you.
> Anna

what/which part is not imported(?)...
do you use all three output args(?)...

help xlsread;

us
From: TideMan on 25 Apr 2010 18:16
On Apr 26, 8:38 am, "Anna L-N" <s0793...(a)sms.ed.ac.uk> wrote:
> Hello,
>
> I have 2 excel files which  have to be imported into Matlab, however, one file is not imported fully, only one part of it, even though in open office document the file looks intact. Does anybody know why that is the case?
>
> Thank you.
> Anna

So, you're taking an OO spreadsheet .ods file and trying to read it
into Matlab?
Or are you saving it as an Excel .xls file? If so, which Excel format
are you using?

IMHO, your problem lies with converting OO to Excel and has nothing to
do with Matlab.
You may be better to save it as a .csv file and import that into
Matlab.
From: Anna L-N on 25 Apr 2010 19:11
Dear "TideMan",

thank you, yes, I think you were right -- the problem was in "interference" between OO and microsoft office. I deleted the trial version of microsoft and now my .csv looks normal now, and matlab recognises all of it!

Thank you!

Anna

TideMan <mulgor(a)gmail.com> wrote in message <003c10af-ce11-4eb0-a5fe-5d949f1e2b8f(a)x18g2000prk.googlegroups.com>...
> On Apr 26, 8:38 am, "Anna L-N" <s0793...(a)sms.ed.ac.uk> wrote:
> > Hello,
> >
> > I have 2 excel files which  have to be imported into Matlab, however, one file is not imported fully, only one part of it, even though in open office document the file looks intact. Does anybody know why that is the case?
> >
> > Thank you.
> > Anna
>
> So, you're taking an OO spreadsheet .ods file and trying to read it
> into Matlab?
> Or are you saving it as an Excel .xls file? If so, which Excel format
> are you using?
>
> IMHO, your problem lies with converting OO to Excel and has nothing to
> do with Matlab.
> You may be better to save it as a .csv file and import that into
> Matlab.
 | 
Pages: 1
Prev: power spectral density
Next: lsqnonlin, badly scaled matrix