How to save output of variable in csv file?
738 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
tejasvee
am 17 Jun. 2017
Kommentiert: Star Strider
am 4 Mai 2023
I have MATLAB code and output is saved in variable and i want to save in csv file. And there is no example of that in doc of MATLAB. I have attached the code and variable name is"TY".
0 Kommentare
Akzeptierte Antwort
Star Strider
am 17 Jun. 2017
See the documentation on the csvwrite (link) function. It was introduced prior to R2006a, so you should have access to it. There are similar functions linked to in and at the end of that documentation page.
1 Kommentar
Star Strider
am 4 Mai 2023
Weitere Antworten (2)
Md. Al-Imran Abir
am 4 Jul. 2022
At present, csvwrite (documentation) is not recommended. If one has a newer version of MATLAB (2019a or later), writematrix (documentation) is the preferred way.
0 Kommentare
Erika Joh
am 26 Apr. 2019
Bearbeitet: Erika Joh
am 26 Apr. 2019
4 Kommentare
Shekhar Vats
am 28 Apr. 2021
This is a stupid bruteforce method, if you find a better one please share. I have seen people just pointing to the default matlab way where you can save one variable. What if you have 1000's of variable that will take all the time. I hope someone will share a better code
Please use the following link: https://www.mathworks.com/matlabcentral/fileexchange/28343-column-converter-for-excel
for downloading xlscol function
clear all; close all; clc;
current_dir = pwd;
[Filename, Pathname] = uigetfile('Select File'); % select file
file_to_be_loaded = [Pathname '\' Filename]; % get file path and name
load(file_to_be_loaded); % load file
Filename
clear Pathname file_to_be_loaded current_dir
vars=who;
sheet = 1;
for n=1:size(vars)
n
xlRange = [xlscol(n) '1'];
xl_range = [xlscol(n) '2'];
xlswrite([Filename(1:end-4) '.xlsx'],cell(vars(n)),sheet, xlRange)
xlswrite([Filename(1:end-4) '.xlsx'],eval(char(vars(n))),sheet, xl_range)
end
cillian thomas
am 4 Mai 2023
A better way is to put the variables in a matrix, and export the data. See this thread:
xout1 = [1 2 3]
yout1 = [4 5 6]
m = [xout1,yout1]
csvwrite('filename.csv',m)
Siehe auch
Kategorien
Mehr zu Text Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!