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

main.m
% Open an existing Excel workbook
excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open('C:\path\to\workbook.xlsx');

% Select a worksheet
sheet = workbook.Sheets.Item('Sheet1');

% Define your cell array
data = {'Name', 'Age', 'City';
        'John Doe', 25, 'New York';
        'Jane Smith', 30, 'London';
        'Bob Johnson', 45, 'Paris'};

% Get the size of the data
[num_rows, num_cols] = size(data);

% Get the range to write the data
start_cell = sheet.Range(sprintf('A%d', 1));
end_cell = sheet.Range(sprintf('%s%d', char('A' + num_cols - 1), num_rows));
range = sheet.Range(start_cell, end_cell);

% Write the data to the range
range.Value = data;

% Save the workbook and close it
workbook.Save();
workbook.Close();
excel.Quit();
761 chars
29 lines