Imported Numbers from excel are replaced by NaN!!(?)

Hello! I am trying trying to import(create a numeric matrix) some values from excel which have about 13 decimals but matlab relpaces them with NaN. What can I do?

[John D'Errico]

Well, since we cannot replicate what you get, how can we help? Posting a spreadsheet where this happens, then showing how you tried to do the import would make it easier to help you. Attach a spreadsheet to a comment.

[Panos Ale]

Here is the file! Thank toy for your help and understanding!

Answer 1

[Walter Roberson]

importdata() cannot deal with using comma as the decimal separator.

Unfortunately to handle numbers that use comma as the decimal separator, you must replace the command with period before converting to numeric. For example if you have a cell array of strings, then

numeric_data = str2double( regexp(YourCellArrayOfStrings, ',', '.') )

[Panos Ale]

Thank you very much!!

Answer 2

[Star Strider]

The NaN values in the numeric output matrix usually occur if the Excel file cells are blank or have string data. Without seeing your Excel file, it is not possible to determine exactly what the problem may be otherwise.

[Star Strider]

This works for me:

[D,S] = xlsread('Panos Ale nums.xlsx');
Sr = regexprep(S(2:end,3), ',', '.');
Data = [D(:,1:2) str2double(Sr)];

I get no NaN values.

[Panos Ale]

I did it this way and it works fine for me too! Thanks!

[Star Strider]

My pleasure!