Get selected range in Excel file using MATLAB
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I have seen a MATLAB GUI program that is able to open the Excel file and get the range of the cells that the user have selected. This value is returned to MATLAB.
I have no idea how it is possible since the Excel file is normal without any macro. Additionally, when MATLAB opens an Excel file, it does not run anymore so how possible can we obtain anything from Excel ?
Thank you very much in advance.
0 commentaires
Réponse acceptée
Fangjun Jiang
le 9 Sep 2011
The function is probably uiimport. Type uiimport in Command Window to start.
You can also use xlsread(). Type help xlsread to find out.
4 commentaires
Fangjun Jiang
le 9 Sep 2011
That's true. You could open the .xls file outside of MATLAB, select the data and copy it (press Ctrl+C), then at the first dialog of uiimport, Select "Clipboard" instead of "File". I just did it and it works.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!