how to read excel data
1 次查看(过去 30 天)
显示 更早的评论
Hello everyone,
I want to create a function which will read data from a given excel file and will return different vectors, each corresponding to a different vector (numerical data only). Do you have any idea?
thank you
0 个评论
回答(1 个)
Azzi Abdelmalek
2014-1-30
To get numerical data
v=xlsread('your_file.xlsx')
5 个评论
Azzi Abdelmalek
2014-1-30
This doesn't make any sens, you are just replacing the function xlsread by Transformation. Just write
K=xlsread('yourfile.xls')
Then do whatever you want with the matrix K. And it's a bad idea to separate it to many vectors. If you want a third column, you can get it by
K(:,3)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!