How can I print names of files or folders contained in a specific folder in first row in excel sheet?

1 次查看（过去 30 天）
ahmed obaid
ahmed obaid 2015-7-6
评论： ahmed obaid 2015-7-16
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
  1 个评论
ahmed obaid
ahmed obaid 2015-7-16
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Shiran Golan
Shiran Golan 2015-7-14
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by