refer to excel data using excel column numbers ?

2023 7 14
1 个回答
更新时间：2023 8 16
2 次查看（30 天）

0 个投票

I read in a large excel data file using readmatrix :
data = readmatrix('press.xlsx');
I would like to refer to the data by the original column names in excel - for example, for the third column, something like :
x = data(:,'C')
This runs but produces wrong results - Any way to make this work ? Thanks

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

回答（1 个）

Voss
Voss 2023-7-14

0 个投票

Use readtable instead of readmatrix.

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Voss
Voss 2023-8-15
@Ambady Suresh: Did this answer work for you?
Ambady Suresh
Ambady Suresh 2023-8-16
@Voss - Yes and No. The read table works as you suggest with column names. However, the return type is different. So I kept getting errors like Operator '-' is not supported for operands of type 'table', etc.
Voss
Voss 2023-8-16
编辑：Voss 2023-8-16

When data is a table, you would say:

x = data{:,'C'}

or:

x = data.C

Please see:

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html

请先登录，再进行评论。

类别

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

标签

编辑：

Voss
Voss
2023-8-16

Community Treasure Hunt

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

Start Hunting!

Translated by