Using Excel files in function

1 次查看（过去 30 天）

显示更早的评论

Perturabo 2019-2-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/443694-using-excel-files-in-function

评论： Mahesh Sharma 2019-7-27

采纳的回答： Bob Thompson

I have a spreadsheet of list of cities and distances between them such as

New York Washington DC Los Angeles

New York 0 500 . 1000

Washington DC 500 0 . 1500

Los Angeles 1000 1500 0

how do i create a function which takes 2 cities as input and gives the distance as output, given that invalid city names give 0 as distance?

I tried a few things but honestly I don't know how to proceed with this problem.

2 个评论
显示无隐藏无

Bob Thompson 2019-2-7

Could you expand a little on what things you tried, and why they didn't work? That will help us give you a more clear answer, rather than something super general.

Perturabo 2019-2-7

编辑：Perturabo 2019-2-7

I tried reading the excel raw data into a matrix and returning the element at m,n where m and n are the cities. But it doesn't work and it returns the whole cell array itself. But honestly I didn't understand file I/O in MATLAB enough to handle functioning with excel.

请先登录，再进行评论。

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

采纳的回答

Bob Thompson 2019-2-7

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/443694-using-excel-files-in-function#answer_359985

编辑：Bob Thompson 2019-2-7

This is a quick first cut, so you will likely need to do some fine tuning of your own. I am assuming that your city distance data is one large square array, with city names in first row and first column.

function [distance] = city_distance(city1,city2);
% Read in the city data, keeping all data in cells
[~,~,data] = xlsread('mycityfile.xlsx');
% Check for first city
c1 = cellfun(@(x) strcmp(x,city1),data(:,1)); % Edit
if c1 == 0;                                   % Edit
    error('No match was found for the first city.')
end
% Check for the second city
c2 = cellfun(@(x) strcmp(x,city2),data(1,:)); % Edit
if c2 == 0;                                   % Edit
    error('No match was found for the second city.')
end
% Distance determination
distance = data{c1,c2};
end

11 个评论
显示 9更早的评论隐藏 9更早的评论

Priyamvada Shankar 2019-3-23

Have you got that where you went wrong,if yes then help me also... I'm too stuck in this question.

Mahesh Sharma 2019-7-27

在 MATLAB Online 中打开

hey

try this one , this works.

function distance = get_distance(A,B)
[~,~,raw] = xlsread('Distances.xlsx');
distance = -1;
for i = 2 : size(raw,1)
   if strcmp(A,raw{1,i})
       for j = 2 : size(raw,2)  
           if strcmp(B,raw{j,1})
           distance = raw{j,i};
           return
           end
       end
   else
      distance = -1; 
    end
end
end