Reading text and data from excel

I am trying to read in an excel file that has both text and numbers into matlab. Using xls read it does not give me all the text but some... Some of its shows up as Nan or Var1 Var2 ect... and same thing with readtable...

[Divija Aleti]

Hi,

Could you please attach your excel file ?

Answer 1

[Divija Aleti]

Hi Austin,

You can try using the following tool:

Import Tool

This can produce outputs as tables rather than a rigid numeric / string matrix. So, it can handle different data types with ease.

Hope this helps!

Regards,

Divija