reading excel and doing computation on the same excel with .exe created for the .m file
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Akshay Ratnaparkhe
il 5 Apr 2017
Risposto: Akshay Ratnaparkhe
il 10 Apr 2017
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 Commenti
Risposta accettata
ES
il 5 Apr 2017
data = xlsread('a','A3:A121') Why is a in quotes here??? It should be like below.
data = xlsread(a,'A3:A121')
0 Commenti
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!