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().
Reading data from excel
1 次查看(过去 30 天)
显示 更早的评论
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???
0 个评论
回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!