What is the command in MATLAB to save an Excel file?
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
Walter Roberson
on 20 Jul 2015
xlswrite() ?
If ABAQUS is not saving the file, then what mechanism are you using to read it in MATLAB ?
5 Comments
Walter Roberson
on 20 Jul 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
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!