Help: Excel manipulation in Matlab
2 次查看(过去 30 天)
显示 更早的评论
Hi,
I have some questions and hope somebody help me. I'm working with excel input data. It's in colum A, B, C , D, etc. The number of colums is not specified. It depends on users. How could I know the number of the colums on each different situation? And with a same "for loop" statement, how could I automatically execute with colums A, B, C, etc.
Khanh
0 个评论
采纳的回答
Iain
2014-9-16
You probably don't need a for loop:
The function "xlsread" reads in the contents of an entire sheet (ALL columns), by default, but you can also set it up so that it makes you select the region of pixels to be imported to matlab.
What you do with your 3 matrices of values & text is up to you.
[numbersonly textonly everything] =xlsread(filename,sheetno);
更多回答(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!