Thread Subject: Beginners trouble reading .xls file

I am simply trying to read a .xls file into matlab using the xlsread function, and do some basic plotting etc. however it cant "see" the first column of data which are the dates.


What can i be doing wrong ?


Thanks

DoVile Last Name:
Did you get all three output arguments of xlsread()? Did you look at each of them?

"Image Analyst" wrote in message <jgi5n2$pp5$1@newscl01ah.mathworks.com>...
> DoVile Last Name:
> Did you get all three output arguments of xlsread()? Did you look at each of them?


I used all three:
filename = 'Matlab Programs\EF_data1.xls';
sheetname = 'Data';
range = 'A1:E377';
data = xlsread(filename);

"DoVile Last Name:" wrote in message <jgimud$e9c$1@newscl01ah.mathworks.com>...
> "Image Analyst" wrote in message <jgi5n2$pp5$1@newscl01ah.mathworks.com>...
> > DoVile Last Name:
> > Did you get all three output arguments of xlsread()? Did you look at each of them?
>
>
> I used all three:
> filename = 'Matlab Programs\EF_data1.xls';
> sheetname = 'Data';
> range = 'A1:E377';
> data = xlsread(filename);



I meant to write:

I used all three
filename = 'Matlab Programs\EF_data1.xls';
sheetname = 'Data';
range = 'A1:E377';
data = xlsread(filename,sheetname,range);

"DoVile Last Name:" <thedreamshaper@gmail.com> wrote in message
news:jgipga$lbb$1@newscl01ah.mathworks.com...
> "DoVile Last Name:" wrote in message
> <jgimud$e9c$1@newscl01ah.mathworks.com>...
>> "Image Analyst" wrote in message
>> <jgi5n2$pp5$1@newscl01ah.mathworks.com>...
>> > DoVile Last Name:
>> > Did you get all three output arguments of xlsread()? Did you look at
>> > each of them?
>>
>>
>> I used all three:
>> filename = 'Matlab Programs\EF_data1.xls'; sheetname = 'Data';
>> range = 'A1:E377';
>> data = xlsread(filename);
>
>
>
> I meant to write:
>
> I used all three
> filename = 'Matlab Programs\EF_data1.xls'; sheetname = 'Data';
> range = 'A1:E377';
> data = xlsread(filename,sheetname,range);

That's not what Image Analyst suggested.

http://www.mathworks.com/help/techdoc/ref/xlsread.html

"[num,txt,raw] = xlsread(filename) reads data from the first worksheet in
the Microsoft Excel spreadsheet file named filename and returns the numeric
data in array num. Optionally, returns the text fields in cell array txt,
and the unprocessed data (numbers and text) in cell array raw."

Call XLSREAD with three OUTPUT arguments (and your three input arguments)
and look at all three of them. Two of them should contain the information
you're looking for.

--
Steve Lord
slord@mathworks.com
To contact Technical Support use the Contact Us link on
http://www.mathworks.com

On Feb 4, 3:16 am, "DoVile Last Name:" <thedreamsha...@gmail.com>
wrote:
> data = xlsread(filename,sheetname,range);
--------------------------------------------------------------------------------------

NO. Those are INPUT arguments. Look at the help for xlsread and look
at the very first way it says to use it:

[num,txt,raw] = xlsread(filename)

Did you do it that way? No you didn't. Try it like it suggests:
[data textCells, rawCells] = xlsread(filename,sheetname,range);
and see what's in all of the output arguments it returns.