Importing multiple .xlsx files to automate data processing

2019 7 6
1 个回答
更新时间：2019 7 6
12 次查看（30 天）

0 个投票

Hi All,
Currently, I am using the readtable function to import .xlsx files into MATLAB and then convert the table to an array, using table2array, in order to manipulate the data. In order to manipulate the data set I need to put the dataset in the matlab directory and copy the filename into the readtable function. Is there an easier way to import data like this? I am interested in selecting a single folder and having MATLAB import all .xlsx datasets in that folder. Ideally, the files could be selected in some sort of order of priority. Hopefully this makes sense!

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

回答（1 个）

Rik
Rik 2019-7-6

0 个投票

I would suggest using dir to create a list of the files and then parsing them in a loop. Probably using xlsread directly is a smarter way to read excel to an array.

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by