Help reading Excel files
조회 수: 2 (최근 30일)
이전 댓글 표시
How do I let MATLAB know how many columns in my Excel file when I'm loading it in a GUI? Let's say I have 22 values in the first column. How can I let MATLAB know it was a 22nd column or n-th column?
I hope someone can help me with some code example for my learning.
댓글 수: 0
답변 (1개)
Héctor Corte
2012년 1월 10일
With this code you get value on cell (A , fila):
ActivesheetRange = get(Activesheet,'Range',['A',num2str(fila)]);
To check if this cell is empty you can use:
isnan(ActivesheetRange.value)
Make a loop that looks for a empty cell along a row and you will get how many columns you have.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!