Renaming Excel Files Using MATLAB Code

45 ビュー (過去 30 日間)
Faroq Al-Rjoub
Faroq Al-Rjoub 2020 年 3 月 21 日
編集済み: Subhamoy Saha 2020 年 3 月 21 日
Hi Matlab
I have a lot of Excel files that i am trying to rename by deleting the first almost 80 characters in the names. The length of the names differ from on file to another. I am trying to keep the last 7 characters in the name. Here is an example of the current name of the file, Submit LEGO Kit Inventory Sheet Here_PulpFiction_attempt_2018-03-19-00-00-22_LegoPartInventory_TEAM852 an I try to rename it to TEAM852. Remember that the length of the names differ. I need a code that would allow me to choose the folder that contains all files that need the name changed, then change the name of the all files by deleting all the characters except the last 7 characters. Please Help.
Thank you

回答 (1 件)

Subhamoy Saha
Subhamoy Saha 2020 年 3 月 21 日
編集済み: Subhamoy Saha 2020 年 3 月 21 日
Change the file extension according to your need.
datafolder=uigetdir();
% files=dir(datafolder); % if you don't have any subfolder or other type of files then you can use this line
files=dir([datafolder '\*.xlsx']); % if you have subfolders or different type of files
for kk=1:length(files)
oldname=fullfile(datafolder,files(kk).name);
[~,fname,ext]=fileparts(files(kk).name);
fname=fname(end-8:end); % taking only last 7 characters excluding extension
newname = fullfile(datafolder,[fname,ext]);
movefile(oldname, newname);
end
Or you can use the following code. You have to select any one file in your desired folder. The following code will rename all those files having with similar file extension. It is also applicable where the selected folder conatins mixed type of files or subfolders.
[file,datafolder]=uigetfile('*.*');
[~,~,ext]=fileparts(file);
files=dir([datafolder, '*', ext]);
for kk=1:length(files)
oldname=fullfile(datafolder,files(kk).name);
[~,fname,ext]=fileparts(files(kk).name);
fname=fname(end-8:end); % taking only last 7 characters excluding extension
newname = fullfile(datafolder,[fname,ext]);
movefile(oldname, newname);
end

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by