seeking help with xlswrite function
显示 更早的评论
Hi,
I'm trying to loop through this code 3 times and save the variable states to the excel file. I want to name the excel files 1.xls, 2.xls and 3.xls.
Could anybody tell me what I am doing wrong with the xlswrite as it is not working. Thank you.
for j=1:3
transC = [zeros(size(T,1),1), cumsum(T,2)]; %cumulative sum of rows, we will use this to decide on the next step.
n = 10000;
states = zeros(1,n); %storage of states
states(1) = 32; %start at state 1 (or whatever)
for ii = 2:n
%Generate a random number and figure out where it falls in the cumulative sum of that state's trasition matrix row
[~,states(ii)] = histc(rand,transC(states(ii-1),:));
end
xlswrite('C:\j.xls',[states],'Sheet1', 'A2');
end
1 个评论
Matt J
2013-1-6
We're waiting for you to tell us what the outcome of the code is.
采纳的回答
Image Analyst
2013-1-6
You need to construct the filename properly. Replace this:
xlswrite('C:\j.xls',[states],'Sheet1', 'A2');
with this:
baseFileName = sprintf('%d.xls', j);
fullExcelFileName = fullfile(yourFolder, baseFileName); % yourFolder can be pwd if you want.
xlswrite(fullExcelFileName ,[states],'Sheet1', 'A2');
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
