loading in a folder of excel files

I have a folder of excel files and I want to load in all of the data from all the files into Matlab to analyze the data. There are about 50,000 files and 100 pieces of data in each. How can I get Matlab to load in all of the data at once without having to do each file manually?

댓글 수: 4

Pieter Hamming
Pieter Hamming 2018년 8월 15일
As Stephen commented: use a for loop over all the file names. If needed, use dir(*.xlsx) to get a list of all excel files in the current directory.
Getting the data from each file is probably easiest using xlsread.
Bob Thompson
Bob Thompson 2018년 8월 15일
xlsread with a for loop is definitely the simplest way to get the data, but you might investigate the ActiveX capability for quicker usage.
Adam Danz
Adam Danz 2018년 8월 15일
If you get stuck, try searching for the answer first. This task has been addressed very many times here in the forum.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

도움말 센터File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

질문:

2018년 8월 15일

댓글:

2018년 8월 15일

Community Treasure Hunt

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

Start Hunting!

Translated by