Do matlab requires Excel as an application in order to create xlsx file?

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?

Answer 1

[Image Analyst]

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.

[vaibhav joshi]

Thank you @Image Analyst. I do beleive it should work, could not find any written proof yet. I dont have the machine yet, so cannot check. It is a preparatory call :)

[Image Analyst]

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.

Answer 2

[Chanheung Cho]

Using num = xlsread(filename), you can read the xlsx format file.

And then save the file as a xlsx form after you finished the modification.

[vaibhav joshi]

@Chanheung Cho Thank you for an answer. Question is do Matlab function xlsread, or xlswrite inherently requires 'Excel' to be installed on Windows machine?

[Chanheung Cho]

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.

[vaibhav joshi]

Thank you Chanheung Cho. Matlab can read. I beleive that Matlab can write too, with some limitations.