Extracting data from excel

Question

Salaijobhaka 2017-4-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/335782-extracting-data-from-excel

回答： dpb 2017-4-17

Capture.JPG

Hi I would like to extract data from a column in which the second row contains string "P5" (Figure attached). One way is to use "xlsread('filepath/data.csv','DQ:DQ')". In this case one need to look at corresponding excel column index, i.e., "DQ". Is there a way in which one can extract data without looking at excel column index but using the string index, i.e., "P4" instead ?

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

请先登录，再进行评论。

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

Answer 1

dpb 2017-4-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/335782-extracting-data-from-excel#answer_263313

With "pure" Matlab-supplied functions, no. You would have to do it indirectly, reading the header row then finding the desired string location therein. As xlsread is quite slow already, almost surely at least as fast to simply just read the full sheet and save what you're interested in.

I'm sure it's also possible with COM to write specific commands but that becomes an Excel VBA syntax problem, not Matlab once the automation server is created.