How can I load and save a excel data file (which has negative values in some rows) in MATLAB as an executable double. I tried and it gives me NAN for negative values. Here is the file. Thanks.

Hello I am using MATLAB 2018a. How can I load and save a excel data file (which has negative values in some rows) in MATLAB as an executable double. I tried and it gives me NAN for negative values. Here is the file. Thanks.

[Stephen23]

What is an "executable double" ?

Answer 1

[the cyclist]

The problem is that in the Excel file, those are not negative signs in those numbers -- they are dashes or some other character. Therefore, they are interpreted as text, not as numbers.

If you globally replace those characters with negative signs (i.e. hyphens), then

x2 = xlsread('index2.xlsx')

will read it just fine. I've done that in the attached file.

[az]

Thank you Cyclist, but for some reason in my matlab version 9.4 it is not reading. Still swing NAN for those negative values in 3rd, 6th, and 9th columns.

[az]

I am sorry, yes it is reading actually for your modified file. So the question is how can I save the excel file replacing -ve sign with hypen?

[the cyclist]

What I did to create my index2 file was to go into a single cell, and copy that dash symbol onto the clipboard. Then I did a global replace with a hyphen, and save.

[az]

Thank you Cyclist, it works, and now on I am changing all file in excel for -ve to hyphen.

Answer 2

[madhan ravi]

[num,~,~] = xlsread('index.xlsx')

Datas = num

Now we can manipulate the data’s as we want.

[madhan ravi]

Didn’t it work?

[the cyclist]

If you take this approach, you will again lose the "negative" values, because they are not stored as numbers. (See my answer.)

You would need to at least do

[num,txt,~] = xlsread('index.xlsx');

to bring in the fields that Excel is storing as text, and then manipulate those in MATLAB. But I think my preferred solution would be to fix those within Excel itself.

[madhan ravi]

Thank you cyclist:)

[az]

Thank you ravi for quick response, but still NAN remains after running this code.

[madhan ravi]

Follow cyclist’s instructions