Do matlab requires Excel as an application in order to create xlsx file?
20 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
vaibhav joshi
el 20 de Oct. de 2022
Comentada: vaibhav joshi
el 21 de Oct. de 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 comentarios
Respuesta aceptada
Image Analyst
el 20 de Oct. de 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 comentarios
Image Analyst
el 20 de Oct. de 2022
Editada: Image Analyst
el 20 de Oct. de 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.
Más respuestas (1)
Chanheung Cho
el 20 de Oct. de 2022
And then save the file as a xlsx form after you finished the modification.
3 comentarios
Chanheung Cho
el 20 de Oct. de 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.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!