load a folder of excel files

5 次查看（过去 30 天）

显示更早的评论

Kamyar Mazarei 2021-6-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/852825-load-a-folder-of-excel-files

评论： Stephen23 2021-6-11

采纳的回答： KSSV

i have 146 excel files in a folder and want to load them all

i dont want to go through import window everytime, so is there a way to load all at once?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2021-6-11

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

请先登录，再进行评论。

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

采纳的回答

KSSV 2021-6-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/852825-load-a-folder-of-excel-files#answer_721585

在 MATLAB Online 中打开

excelFiles = dir('*.xlsx') ; 
N = length(excelFiles) ;
for i = 1:N
    file = excelFiles(i).name ;
    T = readtable(file) ;
    % do what you want 
end

2 个评论
显示无隐藏无

Kamyar Mazarei 2021-6-11

thank you

the T gives me a table, can i turn it into a matrix?

(the excels are all numbers not letters)

Stephen23 2021-6-11

"the T gives me a table, can i turn it into a matrix?"

https://www.mathworks.com/help/matlab/ref/readmatrix.html

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 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