What is the command in MATLAB to save an Excel file?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I'd like to automate a loop:
1. ABAQUS generates a Excel file;
2. Matlab utilises data in Excel file;
3. loop 1 and 2.
Now my question is: after step 1, the Excel file from ABAQUS is unsaved as Book1. I cannot use Matlab command to save it. Is there a command to save Excel file as something? (I assume that Excel always saves the file even though user doesn't?)
Thank you!
0 commentaires
Réponses (1)
Walter Roberson
le 20 Juil 2015
xlswrite() ?
If ABAQUS is not saving the file, then what mechanism are you using to read it in MATLAB ?
5 commentaires
Walter Roberson
le 20 Juil 2015
ABAQUS generating an Excel file is not the same as Excel being active and accessible from MATLAB.
But if Excel is currently active and if you are using MS Windows, then you can use ActiveX to talk to it; see for example http://www.mathworks.com/matlabcentral/answers/94822-are-there-any-examples-that-show-how-to-use-the-activex-automation-interface-to-connect-matlab-to-ex
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!