MATLAB Answers

Rename excel worksheets based on other file names in a folder

14 views (last 30 days)
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?

  0 Comments

Sign in to comment.

Accepted Answer

fred  ssemwogerere
fred ssemwogerere on 13 Feb 2020
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

  4 Comments

Show 1 older comment
Melody Lyu
Melody Lyu on 13 Feb 2020
Thank you Fred.
If I have a list of filenames in matlab, shouldn't I be able to run through the list and import them into the worksheets? I want to create a for loop for it so I don't have to hard code this.
fred  ssemwogerere
fred ssemwogerere on 13 Feb 2020
Sure. That could do. But their order should match the order of the imported files.
Melody Lyu
Melody Lyu on 13 Feb 2020
for i=1:size(C,2)
xlswrite('myFile.xlsx',C{i},files1{1,i});% where files has 1x23 cell array for filenames
end
Got it, thanks!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!