reading excel and doing computation on the same excel with .exe created for the .m file
1 次查看(过去 30 天)
显示 更早的评论
Hello, Please suggest thoughts on below:- I am looking for an executable file from the .m file which can allow me to take excel file as input from the user. In the same .m file I am doing some computation and displaying results. Currently I can take the excel file through the .exe using below command:-
[filename, pathname] = uigetfile({'*.xlsx'},'File selector');
After this I am adding both pathname and filename and using as address for the xlsread command like below- a = strcat(pathname, filename) data = xlsread('a','A3:A121')
but I failed to read the excel. Please let me know anything I am missing/doing wrong.
Thank you, Akshay
0 个评论
采纳的回答
ES
2017-4-5
data = xlsread('a','A3:A121') Why is a in quotes here??? It should be like below.
data = xlsread(a,'A3:A121')
0 个评论
更多回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!