Function to read find title of an excel column

Question

Michael 2011-6-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9802-function-to-read-find-title-of-an-excel-column

回答： Ahmed Elsherif 2018-11-22

I'm looking for a way to identify a specific column in an excel document based on the header of the column.

I have documents with a bunch of columns of data with different titles in different orders. I want to pick out the column with a specific title and make a matrix out of the data in that column. (I can't just use the number of the column because the order varies depending on the document)

Do you know any function that can help with that?

Thanks!

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

请先登录，再进行评论。

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

Answer 1

Oleg Komarov 2011-6-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9802-function-to-read-find-title-of-an-excel-column#answer_13467

在 MATLAB Online 中打开

Import the excel sheet:

[data, text] = xlsread(...);

Now, use:

idx = strcmpi(text(1,:),'HeaderIamLookingFor')
data(:,idx)

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

请先登录，再进行评论。

Answer 2

Ahmed Elsherif 2018-11-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9802-function-to-read-find-title-of-an-excel-column#answer_348366

在 MATLAB Online 中打开

Hi,

I tried this but I got a wrong value. I typed a certain header name but I got the value under a different header!

Would you please tell me why this happens?

With the code below, I got the value under another header ('Start ch.')

Thanks in advance

handles.fileName = uigetfile ('.xlsx')
 [data, text] = xlsread('LT2MELT');
 r = strcmpi(text(1,:),'Zero_Chann.')
k=data(:,r);
set(handles.edit40,'string', k);