Excel file import Infinite value numbers

Hello,

I have a excel table and there are some Inf value.. When I import this excel file into m.files all Inf number is seen as NaN. However, this changing lead some problem. Can you know how to fix it?

Answer 1

[madhan ravi]

Try using readtable() to read the file

[Ali Aygün]

Now, it work however first row is shown as variable name and I have one missing row. Do you know how to fix it

[madhan ravi]

which row is missing? upload the file