Create a new excel file from trimmed data
5 次查看(过去 30 天)
显示 更早的评论
Hi there,
I have data of different activities. Each activity is repeted three times. Previously in the code the activities and the respctive three trials of data are manipulated. Once I have finished manipulating the data I wish to save the new version of the activity data in a new folder called TimeSyncData.
I have managed to achieve this, however, the three trials of the activity land up saving in the same excel file but different sheets. Is there a way of saving the different activity trials in different files rather than having them in one file but in different sheets as it is making it difficult to work with.
%% Folder where the time synchronised data will be saved
OutputFolderName = 'TimeSyncData';
if ~exist(OutputFolderName, 'dir')
mkdir(OutputFolderName);
end
cd(OutputFolderName)
%creating an excel file with the new time synchronised data contained,
%different sheets are the different trials
for i = 1:sz
T = struct2table(trimmed_sync(i));
writetable(T,strcat(activity,'.xls'),'Sheet',"Trial "+i);
end
As seen below activity T04A has three trials but saved in three sheets within the same file. I wish to have three seperate excel files T04A, T04A_1, T04A_2 for the different trials instead.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1145290/image.png)
Any advice would be hugely appreciated. If more code is needed to understand what is being asked please let me know.
Thanks,
Lexi
0 个评论
采纳的回答
dpb
2022-10-4
移动:dpb
2022-10-4
Shure...just build a file name dynamically somehow instead of incrementing the sheet number as you did.
FILES={'T04A', 'T04A_1', 'T04A_2'};
...
...
for i = 1:sz
T = struct2table(trimmed_sync(i));
writetable(T,fullfile(OutputFolderName,strcat(FILES(i),'.xls')),'Sheet','PickASheetNameHere');
end
3 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!