The Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Math Forum » Discussions » Software » comp.soft-sys.matlab

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: xlsread Returns NaN for all numeric data!!!
Replies: 3   Last Post: Mar 24, 2014 11:35 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
Adam Chapman

Posts: 172
Registered: 1/12/09
Re: xlsread Returns NaN for all numeric data!!!
Posted: Mar 22, 2014 6:50 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

On Saturday, March 22, 2014 3:08:09 AM UTC, Mohammed wrote:
> Hi,
> I have an Excel file and Imported it to MATLAB. It contains GPS coordinates (Latitude and Longitude) and temperature values. It is over 100 rows of data and surprisingly, once I run the m file returns NaN for all rows..
> HINT: Excel file saved in the same m-file folder and I double checked all rows are numeric data?!!
> Any solutions fellas?!

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

should write any data format iton the "raw" variable. I expect you data is formatted as text rather than a numeric data type

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.