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

조회 수: 2 (최근 30일)
Jay
Jay 2014년 9월 29일
답변: 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.

채택된 답변

Iain
Iain 2014년 9월 29일
[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.

추가 답변 (1개)

Jay
Jay 2014년 9월 30일
Thankyou, that works perfectly.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by