Reading data from excel

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.

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???

Answer 1

[Fangjun Jiang]

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().