MATLAB limitation in reading from excel ?!

9 visualizaciones (últimos 30 días)
Peyman
Peyman el 24 de Oct. de 2012
Respondida: Pruthvi G el 3 de Oct. de 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?
Thanks
  2 comentarios
Srinivas
Srinivas el 24 de Oct. de 2012
version of MATLAB
Peyman
Peyman el 25 de Oct. de 2012
R2012a (7.14.0.739) - 64-bit

Iniciar sesión para comentar.

Respuestas (2)

Sean de Wolski
Sean de Wolski el 24 de Oct. de 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.
  2 comentarios
Peyman
Peyman el 25 de Oct. de 2012
Ok. But how "reading in chunks" can be done? (beginner)
Ilham Hardy
Ilham Hardy el 25 de Oct. de 2012
Hint:
Use for loop and use the xlrange option of the xlsread command.

Iniciar sesión para comentar.


Pruthvi G
Pruthvi G el 3 de Oct. de 2019

Community Treasure Hunt

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

Start Hunting!

Translated by