Do matlab requires Excel as an application in order to create xlsx file?
12 次查看(过去 30 天)
显示 更早的评论
I need to write some data from matlab Workspace in to xlsx format. However, I dont have Excel installed on my Windows machine. Does Matlab support this xlsx writing without Excel as an Application installed on machine?
0 个评论
采纳的回答
Image Analyst
2022-10-20
I believe MATLAB can still write a .xlsx file even though you don't have Excel installed. Of course, it's easy enough to try -- just one line of code.
2 个评论
Image Analyst
2022-10-20
编辑:Image Analyst
2022-10-20
You can specify whether to use Excel or not. Of course if you try to use it, it must be installed.
writetable options:
UseExcel — Flag to start instance of Microsoft Excel for Windows
false (default) | true
Flag to start an instance of Microsoft® Excel for Windows when writing spreadsheet data, specified as the comma-separated pair consisting of 'UseExcel' and either true, or false.
You can set the 'UseExcel' parameter to one of these values:
- true — The writing function starts an instance of Microsoft Excel when writing the file.
- false — The writing function does not start an instance of Microsoft Excel when writing the file. When operating in this mode, functionality for writing differs in the support of file formats and interactive features, such as formulas and macros.
更多回答(1 个)
Chanheung Cho
2022-10-20
And then save the file as a xlsx form after you finished the modification.
3 个评论
Chanheung Cho
2022-10-20
According to Help Center:
"If your system does not have Excel for Windows installed, or the COM server is not available:
All MATLAB import options read XLS, XLSX, XLSM, XLTM, and XLTX files."
The Matlab can read xlsx file without Excel installed.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!