How to save output of variable in csv file?

729 次查看（过去 30 天）
tejasvee
tejasvee 2017-6-17
评论： Star Strider 2023-5-4
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".

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2017-6-17
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.

更多回答（2 个）

Md. Al-Imran Abir
At present, csvwrite (documentation) is not recommended. If one has a newer version of MATLAB (2019a or later), writematrix (documentation) is the preferred way.
Erika Joh
Erika Joh 2019-4-26
编辑：Erika Joh 2019-4-26
Thanks! Would I just call on the function several times then, like:
csvwrite('filename.csv',variable1,0,1)
csvwrite('filename.csv',variable2,0,2)
etc?
  4 个评论
显示 2更早的评论
Shekhar Vats
Shekhar Vats 2021-4-28
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
cillian thomas 2023-5-4
A better way is to put the variables in a matrix, and export the data. See this thread:
https://uk.mathworks.com/matlabcentral/answers/281156-how-can-i-export-a-matrix-as-a-csv-file
xout1 = [1 2 3]
yout1 = [4 5 6]
m = [xout1,yout1]
csvwrite('filename.csv',m)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by