How to read a string data from excel sheet ? Or to read a single row having charaters

151 次查看（过去 30 天）

Ajay Pherwani 2014-7-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/141299-how-to-read-a-string-data-from-excel-sheet-or-to-read-a-single-row-having-charaters

评论： Paola Carvajal 2018-8-28

I want to read an excel sheet . 1st row all variable names 2: N th row all data

I just want to read the 1st row . Is that possible I have used "dataimport" function , but reads that entire excel sheet ! Is there a way to just read a single row from excel sheet ?

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

请先登录，再进行评论。

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

采纳的回答

Geoff Hayes 2014-7-10

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/141299-how-to-read-a-string-data-from-excel-sheet-or-to-read-a-single-row-having-charaters#answer_144533

在 MATLAB Online 中打开

Consider using xlsread. See xlsread for details and pay particular attention to the use of the xlRange input to this function. If you know the number of columns in the file then you could do something like

[~,txtData] = xlsread('cycling.xlsx','A1:H1')

In the above, we ignore (using ~) the first output parameter which corresponds to numeric data, and instead concentrate on the text data which is returned as a cell array of strings. We use the range 'A1:H1' to return the data in the first row for columns A through H.

Try the above and see what happens!