Do matlab requires Excel as an application in order to create xlsx file?
12 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
vaibhav joshi
il 20 Ott 2022
Commentato: vaibhav joshi
il 21 Ott 2022
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 Commenti
Risposta accettata
Image Analyst
il 20 Ott 2022
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 Commenti
Image Analyst
il 20 Ott 2022
Modificato: Image Analyst
il 20 Ott 2022
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.
Più risposte (1)
Chanheung Cho
il 20 Ott 2022
And then save the file as a xlsx form after you finished the modification.
3 Commenti
Chanheung Cho
il 20 Ott 2022
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.
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!