Renaming a Excel file from an array
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
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)
回答(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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!