thank you sir its working well , only small note if i need to print these names in first column A in excel file , when i have to change arguments or code portion ,,, thanks again
How can I print names of files or folders contained in a specific folder in first row in excel sheet?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
ahmed obaid
am 6 Jul. 2015
Kommentiert: ahmed obaid
am 16 Jul. 2015
For example, if there are 10 folders in a directory, how can I print their names in the first excel row, with the format '1 name for each cell'?
Here is the code of what I tried so far
for folder = 1:length(srcFolders)
path = strcat('D:\',srcFolders(folder).name);
folder_range = strcat(column_range, '1');
xlswrite(xls_filename, {srcFolders(folder).name}, xls_sheet, folder_range);
end
Akzeptierte Antwort
Shiran Golan
am 14 Jul. 2015
this should work:
srcFolders = dir;
for folder = 1:length(srcFolders)
srcFolders(folder).fullname = strcat('D:\',srcFolders(folder).name);
end
xlswrite('xlsFile', {srcFolders(:).fullname}, 'xlsSheet','A1');
Notice that the writing to excel file is only the last row, and the loop only adds the prefix of the path into a new field in the directories struct
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!