MATLAB: Is it possible to create an excel file by MATLAB

excel

I need to create an excel file by MATLAB and write the obtained results in it. Is it possible to generate generate an excel file from Matlab?

Best Answer

Yes. xlswrite() and writetable() can create .xls and .xlsx files in all modern MATLAB versions on all supported operating systems.

More advanced work with Excel files require MS Windows systems with Excel installed.

Related Solutions

MATLAB: Xlswrite to create file with xlsx extension

xlswrite('file.xls',Your_data)

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

Best Answer

Related Solutions

MATLAB: Xlswrite to create file with xlsx extension

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

Related Question