フィルターのクリア

a simple question about for loop

3 ビュー (過去 30 日間)
dediydi
dediydi 2012 年 7 月 19 日
hello all,
i want to use xlswrite function in a for loop ? but i don not know how to name the variable in for
for example ;
for a = (1:10)
xlswrite( 'deneme.xls',writeEx , 1, 'A??')
end
maybe it is simple but very important for my project now. i am looking forwart to hear your answer.
thank you a lot
  1 件のコメント
Walter Roberson
Walter Roberson 2012 年 7 月 19 日
Why are you writing the same value, "writeEx", multiple times?
Is "writeEx" a scalar or a vector or a matrix? Are you trying to write it across rows or down columns or something else?

サインインしてコメントする。

回答 (2 件)

Nirmal
Nirmal 2012 年 7 月 19 日
編集済み: Nirmal 2012 年 7 月 19 日
First of all its loop not loob. I hope you meant range as a variable. the following code should work.
for a = (1:10)
b=sprintf('A%i',a)
xlswrite( 'deneme.xls',writeEx , 1, b)
end
  1 件のコメント
dediydi
dediydi 2012 年 7 月 19 日
it works but not regulary. i want to start to write in excel second row. but when a = (20:50) it starts to write from 20th row. how can i fix it. thank you a lot

サインインしてコメントする。


Azzi Abdelmalek
Azzi Abdelmalek 2012 年 7 月 19 日
for i=1:10
writeEX=rand(10,10); %exemple of random matrix
xlswrite( 'deneme.xls',writeEX ,['Sht',num2str(i)],'A5')
end
% ['Sht',num2str(i)] are the sheet 1 2 3 ... named sht1 sht2 ...
% 'A5' data start at the fifth line of colon A

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by