This is my program:
x= 9;
fprintf(' a z \n _ _ \n');
for a = 0:4
z =x+a;
fprintf(' %d %d\n',a,z);
end
how can i convert the output into excel spreedsheet? or file?
Add a comment
|
1 Answer
The easiest way to get data from Matlab into Excel is writing to a plain text .csv file, then importing that into Excel. To do this, simply open a file
fileID = fopen('mydata.csv','w');
change the fprintf statements to write to that file
x= 9;
fprintf(fileID, ' a, z \n _, _ \n');
for a = 0:4
z =x+a;
fprintf(fileID, ' %d, %d\n',a,z);
end
and make sure to close the file when you are done
fclose(fileID);
Import this into Excel and you can save it as an xls file.
6 Comments
rayryeng
You should note that CSV stands for comma-separated-value, and so columns are delimited by commas. I don't see any commas written in your code.
Urs
true, fixed. Excel would still understand the file, but it should probably be a .txt
Raldenors
how can i save it? as .m?
rayryeng
@Raldenors - The code above already saves it to file. You should see a
mydata.csv file once you finish with the above code.rayryeng
@Urs - Good! Now you get my +1 :)
|