i want to create an excel sheet for A=14/(cos(b))^3,where b varies from 8 to 25(i.e 8,9 ....,25). How to write a programme ?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Rahil Sonkusare
le 11 Sep 2016
Modifié(e) : Guillaume
le 11 Sep 2016
i want to create an excel sheet for A=14/(cos(b))^3,where b varies from 8 to 25(i.e 8,9 ....,25). How to write a programme ?
2 commentaires
Guillaume
le 11 Sep 2016
while it's not hard to do in matlab, it's trivial to do in excel. Since you want the result in excel, why don't you do it directly there?
Réponse acceptée
taher azim
le 11 Sep 2016
this will be ur program
function surfer()
m=zeros(18,1)
for b=8:1:25
A=14/(cos(b))^3;
m((b-8)+1,1)=[a];
end
%create a blank excelsheet in ur matlab directory with a proper filename%
filename = 'filename.xlsx';
xlswrite(filename,m);
end
%to design ur output in excel refer to matlab help section and type xlswrite.%
0 commentaires
Plus de réponses (1)
Guillaume
le 11 Sep 2016
Modifié(e) : Guillaume
le 11 Sep 2016
Well, if you really want to do it in matlab, the efficient way of doing it is:
b = 8:25;
A = 14/cos(b).^3;
xlswrite('full path to your file.xlsx', [b; A]'); %tranposed b and A so they're written by column
Not using slow loops.
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!