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

2 views (last 30 days)
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.

Accepted Answer

Iain
Iain on 29 Sep 2014
[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.

More Answers (1)

Jay
Jay on 30 Sep 2014
Thankyou, that works perfectly.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!