write data from a cellarray into an excelfile with actxserver in matlab

main.m
% Create an instance of Excel and make it visible
Excel = actxserver('Excel.Application');
Excel.Visible = true;

% Create a new workbook
Workbooks = Excel.Workbooks;
Workbook = Workbooks.Add;
Sheets = Workbook.Sheets;
Sheet = Sheets.Item(1);

% Define the cell array to write to Excel
data = {'Name', 'Age', 'Gender'; 'John', 25, 'Male'; 'Mary', 30, 'Female'};

% Get the size of the data to write
[rows, cols] = size(data);

% Create Excel Range object and write the data to it
Range = Sheet.Range(sprintf('A1:%s%d', char('A' + cols - 1), rows));
Range.Value = data;

% Save and close Excel workbook
Workbook.SaveAs(fullfile(pwd, 'data.xlsx'));
Workbook.Close;
Excel.Quit;
675 chars
25 lines