필터 지우기
필터 지우기

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

채택된 답변

ES
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')

추가 답변 (1개)

Akshay Ratnaparkhe
Akshay Ratnaparkhe 2017년 4월 10일
Thank you Smith.. Its working now. Thanks again

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by