MATLAB: Rename excel worksheets based on other file names in a folder

activexdataexcelfilemachine learningMATLABworksheet

I have a folder with 23 files named below:
'9-5365_Kr1.4_Fir.xlsx'
'2-4534_Op4.6_Sec.xlsx'
...
I started with importing the folder in a for loop:
path = 'C:\Users\Documents\MATLAB';
files = dir(fullfile(path, '*.xlsx'));
 for k = length(files):-1:1 %import the 23 files
     filename = [path filesep files(k).name];
     %do something
 end
 myfile = 'C:\Users\Downloads\myfile.xlsx';%the excel file with 23 worksheets of data
How do I rename the worksheets in 'myfile' based on the random names in the folder?

Best Answer

Hello, i think i've dealt with a previous question from you about writing files to different sheets. However, i do not think you can rename the "sheetnames" in Matlab. I advise that this would have been done while writing the files to different excel sheets. Below i have copied part of the code i used in one of the previous questions you asked, but edited some part to show how you can add custom "Sheetnames" during writing of the files to the sheets.
% If "C" is a cell array holding your imported files, and with each having a different name, then create 
% a separate array holding your random names you wish to use for the sheets, say "T". As an example:
T={'9-5365_Kr1.4_Fir','2-4534_Op4.6_Sec'}; % A cell array of random sheet names (should have same length as "C")
for k=1:size(C,2)
    xlswrite('myfile.xlsx',C{k},T{k}); % with "T{k}", Here you are indexing into the cell array of predefined sheetnames
end
Related Question