I have a program which gives its answer in a command window as 400000 values in a single column and I need to run the same program 100 times. Hence that window data needs to save in 100 excel lines and each will get 400000 raw.
Now I want to know is it possible to save/store MATLAB command window data (displayed data) as an Excel file? This can reduce time otherwise I need to run this code 100 times and by copy and paste I need to generate the Excel file.
please see sample matlab code:
clc
clear
disp ('result')
for i=1:10
i=10+i;
rand;
disp(rand);
end
and required result excel sample file is for four run is displayed below
result result result result
0.1183 0.5298 0.0537 0.4021
0.8388 0.5004 0.3855 0.6397
0.249 0.9248 0.0133 0.6769
0.1758 0.7826 0.2807 0.7949
0.1975 0.2909 0.1522 0.8173
0.1744 0.9097 0.535 0.7545
0.5815 0.5147 0.3985 0.8499
0.2362 0.0762 0.396 0.0331
0.7287 0.3873 0.1991 0.1895
0.1929 0.7712 0.9295 0.7071
>> >> >> >>
I got answer, Thank you all and special thanks to Ghulam Rasool
Ghulam Rasool's answer is suitable for my problem
You can use the "diary" command. Here is a simple example
>> diary on
>> (your code and output displayed in the Matlab)
>> diary off
A new file with the name "diary" will be created. You can open the newly created file in MS Excel.
Hi,
Isn't simpler do direct the output from your program to the text file? It is not a problem to import data from the text file to the excell.
If you have the output variable, which temporary value you want to store you can do that:
out = 12 ; % the variable you can store
fid=fopen('data.txt','a+'); %open the data file
fprintf(fid,'%d\n',out); %write the value into the file
fclose(fid); %close the file
Just do the same for the next value you can store.
For more details type: help fprintf
P
You have to make a loop and to write a script that renames the file you want to save and by using the save command the data you have generated is saved on HD. Then you can clear your data before a new loop or you can reinitialize it! In other words: put the program you use in a loop and at the end of the loop put the script that generates the new file name and use the save command, optional: clear the saved data - so that it doesn't overlap and eventually end the loop.
Firstly you have to save answer in variables after that you can save in excel:
xlswrite('file name', your variable);
hello dear
of course you can
please attention to example bellow
filename = 'testdata.xlsx';
A = {'Time','Temperature'; 12,98; 13,99; 14,97};% what you gonna save in excel you can save your variables in A
sheet = 2; % the sheet number
xlRange = 'E1'; % the start point in excel page
xlswrite(filename,A,sheet,xlRange)
i hope the best for you
I think, ecxel could have limitations in the amount of data that can be processed.
You can try "save" command to store output variable in Matlab. In some cases it extremely helpful.
yes u can save data to excel
xlswrite(filename,A,sheet,xlRange)
visit following link
http://www.mathworks.com/help/matlab/ref/xlswrite.html
Dear all,
Thank you very much for your valuable answer but still my problem does not solved.
let me clarify it ones again.
I want to save Matlab command window display values to excel file, and here above solutions are of saving of variables during run and that can not be useful in my problem, If we save this for each variable than it will increase time per run.
So I want to save Matlab command window display values after each run and that program will be run for 100 times.
please see sample matlab code:
clc
clear
disp ('result')
for i=1:10
i=10+i;
rand;
disp(i);
disp(rand);
end
and required result excel file is for four run (please see attached file)
I got answer, Thank you all and special thanks to Ghulam Rasool
Ghulam Rasool's answer is suitable for my problem
You can use the "diary" command. Here is a simple example
>> diary on
>> (your code and output displayed in the Matlab)
>> diary off
A new file with the name "diary" will be created. You can open the newly created file in MS Excel.
Dear Ahmed Fouad Ali, xlswrite command can use to save variable (as per my study) but I got answer that is dairy use to save command display window characters (Ghulam Rasool).
Thanks for encouragement
Hi,
You can also usethe following command to save data in 8-digit ASCII format delimited with tabs:
save filename.txt variablename -ascii -tabs
Thanks bhargav,
diary command is working as per my need, I will try your suggestion .
Thanks for your valuable help
Thank you Ghulam Rasool for your valuable help.
It really solves my problem.
The diary file can also be opened using Notepad. So suitable for me!
- Badges
- Science topic