How to use .xlsx file to import data in a list?
1 次查看(过去 30 天)
显示 更早的评论
hi everyone, i'm working on a matlab GUI, and i have an empty List2 in my code and a file 'D.xlsx' where in the first row there are strings like this
![excel.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/196938/excel.png)
where 'test_2.m' is the name of a script which contains a function.
i want to write this row (using a pushbutton),in my List2 in the code, to obtain:
List2={'test_2','test_2','test_2','test_2'};
How can i use the data in the .xlsx file to do this?
Is it possible?
if not, what can i do?
0 个评论
采纳的回答
Jayaram Theegala
2018-11-29
You can use the "xlsread" function to read the text data that you want.
[~, txt] = xlsread('D.xlsx'); % This should return you the strings in form of Cell Array
For more information about the "xlsread" function, click on the following URL:
Hope this helps!
更多回答(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!