Reading data from excel
2 ビュー (過去 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 件)
Fangjun Jiang
2018 年 11 月 13 日
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 件のコメント
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!