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!