Create matrix and write to excel

Question

Lisa 2014-8-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/151318-create-matrix-and-write-to-excel

编辑： Lisa 2014-8-20

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更早的评论

请先登录，再进行评论。

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

Answer 1

Stalin Samuel 2014-8-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/151318-create-matrix-and-write-to-excel#answer_148942

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)