Reading text and data from excel

2021 6 21
1 个回答
更新时间：2021 6 24
8 次查看（30 天）

0 个投票

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...

请先登录，再回答此问题。

回答（1 个）

Divija Aleti
Divija Aleti 2021-6-24

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by