Reading text from an excel file and populating a matrix with those values.

Question

Jay 2014-9-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/156679-reading-text-from-an-excel-file-and-populating-a-matrix-with-those-values

回答： Jay 2014-9-30

I have read "http://www.mathworks.com.au/matlabcentral/answers/146754-xlsread-not-reading-text-only-excel-file" trying to figure out how to populate a matrix with those values.

So, so far I have:

[num,txt]=xlsread(filename,sheet_4)% Reads the numbers and text

network_station_coordinates = xlsread(filename,sheet_4,(num,txt))% populates the matrix with the prior

% matrix

This does not work.

Can someone please tell me what I need to do in-order to populate the num,txt values into the network_station_coordinates matrix?

Thanks.

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

请先登录，再进行评论。

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

Answer 1

Iain 2014-9-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/156679-reading-text-from-an-excel-file-and-populating-a-matrix-with-those-values#answer_153262

在 MATLAB Online 中打开

[numbers_only text_only both] = xlsread(filename,sheet_4);

Then one of:

 network_station_coordinates = numbers_only; % if you just want numbers
 network_station_coordinates = text_only; % if you just want the text
 network_station_coordinates = both; % if you want both.