Clear Filters
Clear Filters

Reading text and data from excel

4 views (last 30 days)
Austin Matuszewski
Austin Matuszewski on 21 Jun 2021
Answered: Divija Aleti on 24 Jun 2021
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...

Answers (1)

Divija Aleti
Divija Aleti on 24 Jun 2021
Hi Austin,
You can try using the following 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!


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!