Create matrix and write to excel

Lisa

2014 8 18

1 个回答

回答已采纳

1 次查看（30 天）

显示更早的评论

0 个投票

Hi everybody! I have the following problem: I nwant to create a matrix that shows the distance between each of these places. The matrix should then be written into a excel document. Somebody who can help me with the code?

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

请先登录，再进行评论。

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

请先登录再关注

采纳的回答

Stalin Samuel 2014-8-18

0 个投票

clear all lt=[57:10:97] lg=[10:10:50] d=zeros(5,5) for i= 1:5 for j=1:5 dlat=lt(j)-lt(i) dlong=lg(j)-lg(i) a = (sin(dlat/2))^2 + cos(lt(i))*cos(lt(j))*(sin(dlong/2))^2; c = 2*atan2(sqrt(a), sqrt(1-a)); R = 6370;

d(i,j) =round( R*c) end end filename = 'test.xlsx'; xlswrite(filename,d)