清空筛选条件
清空筛选条件

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 次查看（过去 30 天）
Rahil Sonkusare
Rahil Sonkusare 2016-9-11
编辑： Guillaume 2016-9-11
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 个评论
Guillaume
Guillaume 2016-9-11
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?
Rahil Sonkusare
Rahil Sonkusare 2016-9-11
i am in learning phase trying to eplore my matlab knowledge , just out of curiosity i am asking question and will be glad to accept answer.

请先登录，再进行评论。

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

采纳的回答

taher azim
taher azim 2016-9-11
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.%

更多回答（1 个）

Guillaume
Guillaume 2016-9-11
编辑：Guillaume 2016-9-11
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by