write a cell arrray into an excel spreadsheet with the help of activex in matlab

main.m
% create a cell array
data = {'Name', 'Age', 'Gender';
        'John', 25, 'Male';
        'Emily', 30, 'Female';
        'Tom', 40, 'Male'};

% connect to Excel
excel = actxserver('Excel.Application');

% make Excel completely visible
excel.Visible = 1;

% add a new workbook
workbook = excel.Workbooks.Add();

% select the first sheet
sheet = workbook.Sheets.Item(1);

% get the size of the data array
[numRows, numCols] = size(data);

% write each cell in the data array to the Excel sheet
for i = 1:numRows
    for j = 1:numCols
        % convert cell content to string
        content = num2str(data{i,j});
        % write cell to Excel
        Range = get(sheet, 'Range', ['A', 'A'] + [i-1,j-1]);
        set(Range, 'Value', content);
    end
end

% save and close the workbook
workbook.SaveAs(fullfile(pwd, 'data.xlsx'));
workbook.Close();
excel.Quit();
861 chars
37 lines