Importing data from excel in matlab gui
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have made a gui which has 11 variables and a push button which calculates a property based on the input values (neural network). I have around 100 data sets for these 11 variables (in excel) and want to predict the output property for each data set. Doing this manually is time consuming. Is there an easy way out? Please help.
4 commentaires
Al Dente
le 5 Août 2015
Modifié(e) : Al Dente
le 5 Août 2015
have all your excel files in one directory, then:
cd c:\myexcelfilesdirectory % that's the directory that you created for the files
z = dir;
z = {z(3:end).name}; % z(1) is \. z(2) is \..
[num,txt,raw] = cellfun(@(x)xlsread(x), z, 'UniformOutput', 0)
that would read them all at once, will take a while though, you can always loop through them with a for loop instead.
Réponses (1)
Walter Roberson
le 6 Août 2015
Read the file.
Repeat
fetch a row. set() the appropriate handles to contain the values extracted from the row. call the callback routine for the button that activates the calculation, passing in the handle of the button, then [], then the handles structure
pushbutton1_callback(handles.pushbutton1, [], handles)
The calculation will be run.
Do whatever you need to do afterwards. That might include get()'ing the 'String' of a handle to write out to a file.
End of loop.
0 commentaires
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!