MATLAB Answers

MATLAB limitation in reading from excel ?!

4 views (last 30 days)
Peyman on 24 Oct 2012
Answered: Pruthvi G on 3 Oct 2019
Hello everybody!
I need to read data from an excel file in my code, but the file includes more than 500000 rows! (500900 to be accurate) and then do so many calculations and fittings, ... .
What options do I have? Any ideas?

Answers (2)

Sean de Wolski
Sean de Wolski on 24 Oct 2012
doc xlsread
If it can't read it all at once, read it in chunks to not overload the COM Excel Server and process it as you go.
Ilham Hardy
Ilham Hardy on 25 Oct 2012
Use for loop and use the xlrange option of the xlsread command.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!