reading in excel data with a specific heading

3 次查看（过去 30 天）

Davindra Usov 2022-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1743985-reading-in-excel-data-with-a-specific-heading

评论： Davindra Usov 2022-6-20

Hi,

I am trying to write a data processing script which is robust. I'm stuck on how to read in all columns of an excel sheet that has the heading 'Latitudes', as opposed to just coding in the columns G:G, S:S, etc manually. Any suggestions? :)

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

KSSV 2022-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1743985-reading-in-excel-data-with-a-specific-heading#answer_989365

REad about readtable

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

Davindra Usov 2022-6-20

I've managed to use the readtable command to read in the excel sheet but the heading 'Latitudes' is not one of the Var names; instead, it is an entry in one of the cells.

请先登录，再进行评论。

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