Hi Mauro,
I can help you with those basic tasks using MATLAB Interface (.000208DA_0000_0000_C000_000000000046)! Here's how you can tackle your questions:
1. Copying Cells with Formulas between Sheets:
Here's how to copy cells from one sheet to another, including formulas:
% Open the Excel workbook
excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open('your_excel_file.xlsx');
% Get the source and destination sheets
sourceSheet = workbook.Sheets('Sheet1'); % Replace with actual sheet name
destSheet = workbook.Sheets('Sheet2'); % Replace with actual sheet name
% Define the range of cells to copy (replace with your cell range)
sourceRange = sourceSheet.Range('A1:B10'); % Example range
% Copy the range with formulas to the destination sheet
destRange = destSheet.Range('C1'); % Top-left corner of destination range
sourceRange.Copy.PasteSpecial destRange, xlPasteValuesAndFormulas;
% Close the workbook and quit Excel
workbook.Close;
excel.Quit;
2. Inserting Mixed Text with Font Formatting:
To insert mixed text with different fonts in a cell, you can use the Value and Font properties:
% Get the destination cell (replace with your cell reference)
destCell = destSheet.Range('A1');
% Set the mixed text content
destCell.Value = 'Δ Fuel Consumption';
% Apply font formatting (replace with desired font names)
destCell.Font.Name = 'Calibri'; % Set font for most of the text
destCell.Characters.Item(1).Font.Name = 'Symbol'; % Set font for Δ symbol
% (Optional) Set specific font properties for the symbol
destCell.Characters.Item(1).Font.Size = 12; % Example: Set symbol font size
Tips:
- Replace placeholders like 'your_excel_file.xlsx' and cell ranges with your actual data.
- Explore the topics in: https://www.mathworks.com/help/matlab/ref/actxserver.html
