Import a file excel with both strings and numbers

2 次查看（过去 30 天）
Anna Mascaretti
Anna Mascaretti 2021-2-7
评论： Sourabh Kondapaka 2021-2-9
Hello everyone!
I have to import from an Excel file into a Matlab tabel some data that are both strings and numers. If I use readtable, the table I get contains only strings, also the numers are put into '' so then I can work on them as numbers.
What can I do?
Thank you very much.
Anna
  4 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2021-2-7
Given the fact that the code you give "works", I am certain there is another way. However, to tell you what the other ways are and be certain that they would work for you, I would need to know which MATLAB release you are using, and which operating system, and whether you have Excel installed; and I would need an excerpt from the file, the first few lines at least.

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by