Create a new excel file from trimmed data

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.

Any advice would be hugely appreciated. If more code is needed to understand what is being asked please let me know.

Thanks,

Lexi

Answer 1

[dpb]

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    

[alexandra ligeti]

Hi, Thank you for this.

When I place it in my code I get this error...

[dpb]

Show your code; how did you define the OutputFolderName -- it must be the target directory to which you want to write the file....

Make sure the output of the call to fullfile is a valid filename...set a breakpoint in the debugger and check...

[alexandra ligeti]

Hi, I was able to fix the error.

Thank you very much for the help.