How can pull data from multiple excel files?

2 views (last 30 days)
MD Humyom Hossain Chowdhury
Answered: Image Analyst on 6 Jun 2022
In my project i'm told to take data from 720 excel files. Each excel files has multiple sheets. I need one particular data from each of the excel files.

Sign in to answer this question.

Answers (2)

dpb
dpb on 6 Jun 2022
Image Analyst
Image Analyst on 6 Jun 2022
Since this is one of the most common FAQs, see the FAQ for a thorough discussion:
https://matlab.fandom.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
Inside the for loop over your 720 files, put a call to readmatrix, readcell, or readtable.

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!