Renaming a Excel file from an array
显示 更早的评论
Hello everyone!
I am facing problem in renaming my Excel file. I have a defined variable with values (5x1 double)
values=[0.0082;0.0083;0.0086;0.0087;0.0082];
There is a matfile (test.mat) which have values of variables (a,b and c)
All_values=values;
for i =1:numel(All_values)
values=All_values(i)
T = table(a{1,i}.time, oo{1,i}.signals.values, pp{1,i}.signals.values) %values from .mat file
writetable(T{i},'Check_%i.xlsx',values) %somewhere here is the issue
end
What I want is to rename my file like 0.0082.xlsx, then comes 0.0083.xlsx, 0.0086.xlsx, 0.0087.xlsx and 0.0082.xlsx. The code is running fine till the values of T (making a table). Any help to rename the file would be highly appreciated. Thanks!
6 个评论
Sugar Mummy
2022-1-22
Sugar Mummy
2022-1-22
Stephen23
2022-1-22
T = table(..);
writetable(T{i},..)
% ^^^ get rid of this indexing, it will throw an error.
Sugar Mummy
2022-1-22
@Stephen After removing the index, it says...
Stephen23
2022-1-22
Your WRITETABLE call does not follow any syntax shown in the documentation.
It looks you are attempting to create a filename using values, in which case you need to use SPRINTF:
F = sprintf('Check_%i.xlsx',values);
writetable(T,F)
Sugar Mummy
2022-1-23
回答（1 个）
KSSV
2022-1-22
All_values=values;
for i =1:numel(All_values)
values=All_values(i)
T = table(a{1,i}.time, oo{1,i}.signals.values, pp{1,i}.signals.values) %values from .mat file
fname = ['Check_',num2str(i),'xlsx'] ;
writetable(T{i},fname,values)
end
1 个评论
Sugar Mummy
2022-1-22
Hi, thank you for the response Sir but it gives the following error
PS: I am using MATLAB 2019a
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2022-1-22
2022-1-23
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
