Reading data from excel
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hello, guys! I'm trying to write a code which reads data from a spesific column in excel. I am using xlsread comand in matlab code.
![1.jpg](https://www.mathworks.com/matlabcentral/answers/uploaded_files/194907/1.jpeg)
My goal is to write a code wchich reads from the first column. The logic of the program si to check if the cell of the column A is equal to 1, if this statement is met, then take the name from the column B and do it till the first empty cell from the first column.
My question is: How can I say to Matlab (xlsread fun ) to start reading from a sertain cell, and to stop when the code meets the first empty cell of the column???
0 comentarios
Respuestas (1)
Fangjun Jiang
el 13 de Nov. de 2018
I would suggest reading the whole Excel sheet and then process the data in MATLAB according to your logic. xlsread() is more time comsuming than most of the MATLAB functions. Unless your Excel sheet contains huge data, it never pays to read the Excel sheet twice using xlsread().
0 comentarios
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!