Reading an Excel table with both numbers and text

25 次查看（过去 30 天）
Aleem Andrew
Aleem Andrew 2021-12-5
回答： Adam Danz 2021-12-5
I read an Excel table using the readtable function. I wanted to refer to specific values, whether text or numbers, but when I try to extract a specific value such as the value in column 4 and row 3 the output is not simply that string/number but also the heading. To solve this problem, I first used the table2array function but that lead to an error because the table has both text and numbers. An alternative is to read the table using the readmatrix function but the text is not readable in that case. Can anyone explain how the Excel table can be read as a matrix with both text and numbers so when you refer to the value in say column 4 and row 3 that returns only that value, not also the heading?

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

采纳的回答

Adam Danz
Adam Danz 2021-12-5
Use readtable which will read the data in as a table which is 2 dimentional but not a matrix. If you haven't used tables, you may want to review table indexing. This is usually better than using a cell array. Matrices are not an option if you want to store numeric and non-numeric data within the same variable.

更多回答（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