How to selectively save the names and values of some workspace variables to a CSV file?

3 次查看（过去 30 天）

Diaa 2020-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593947-how-to-selectively-save-the-names-and-values-of-some-workspace-variables-to-a-csv-file

评论： Diaa 2020-9-15

Consider the following

a = 3; b=7; c=5; d=9;
save('test.mat')
data = load('test.mat');
toSave = { 'b' ; 'c' };
writecell( horzcat( toSave , <missing code> ) ,'myfile.csv')

what should be the <missing code> in order to have the content of myfile.csv to be

b , 7
c , 5

2 个评论
显示无隐藏无

Rik 2020-9-15

Are b and c guaranteed to be scalar?

Diaa 2020-9-15

Yes, so far.

请先登录，再进行评论。

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

采纳的回答

Rik 2020-9-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593947-how-to-selectively-save-the-names-and-values-of-some-workspace-variables-to-a-csv-file#answer_494773

This should do the trick. If the variables aren't scalars the results might not be what you want.

a = 3; b=7; c=5; d=9;
save('test.mat')
data = load('test.mat');
toSave = { 'b' ; 'c' };
s=struct;
for n=1:numel(toSave)
    s.(toSave{n})=data.(toSave{n});
end
writecell( horzcat( toSave , struct2cell(s) ) ,'myfile.csv')

3 个评论
显示 1更早的评论隐藏 1更早的评论

Rik 2020-9-15

You could also ask load to only retrieve the variables of interest:

s=load('test.mat',toSave{:});

Note that loops have a pretty good performance, as long as you aren't dynamically growing arrays and there isn't a direct function to do it.

Diaa 2020-9-15

I totally forgot the simple way of selective loading.

Thanks for the hint.

请先登录，再进行评论。

更多回答（1 个）

Diaa 2020-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593947-how-to-selectively-save-the-names-and-values-of-some-workspace-variables-to-a-csv-file#answer_494827

Thanks to the inspiring answer of @Rik, I found the following solution without the need to use for loop

a = 3; b=7; c=5; d=9;
save('test.mat')
data = load('test.mat');
toSave = { 'b' ; 'c' };
writecell(horzcat(toSave, cellfun( @(C) data.(C),toSave,'UniformOutput',false)),'myfile.csv')