What is the command in MATLAB to save an Excel file?
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Walter Roberson
2015-7-20
xlswrite() ?
If ABAQUS is not saving the file, then what mechanism are you using to read it in MATLAB ?
5 个评论
Walter Roberson
2015-7-20
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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!