Basic use of Interface.​000208DA_0​000_0000_C​000_000000​000046

I am at the very first use of Interface.000208DA_0000_0000_C000_000000000046, since I need to change an excel, in its fomat and contents, automatically. I have some basic questions, since I have not found clear documentation on them.

1) I know some basic commands, i.e. how to open the excel sheet via "actxserver" and "Workbooks", how to generate "Sheets" objects. I would like to know how can I copy in an excel file, once I have opned it, cells from a sheet to another sheet. These cells shall contain formulas to elaborate the contents of other column that I have generated via a routine of mine.

2) How can I insert in a cell some mixed text, like "Δ Fuel Consumption" (where there is one character using "Symbol" font and the rest is "Calibri")?

Answer 1

[UDAYA PEDDIRAJU]

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

[Mauro Colombano]

Sorry Udaya,

I have started to analyze your answer #1, but it seems to contain some errors:

• in line "sourceSheet = workbook.Sheets('Sheet1');" as an example, it gives me an error, since it is not possible to call excel sheets like that
• Line "sourceRange.Copy.PasteSpecial destRange, xlPasteValuesAndFormulas;" gives me an error as well. Please note that I'm using Matlab 2023a 64bit

Anyway, I have found some code useful for such part, and it works correctly 😉.

I will analyze your second answer, for which I've only found a workaround sofar, without really solving the problem: I will tell you if it solves my issue.

Thanks anyway!

Regards,

Mauro

[Mauro Colombano]

...I have just seen that even the following command in answer #2 doesn't work:

destCell.Characters.Item(1).Font.Name = 'Symbol';

In facts, it returns to me:

Incorrect number or types of inputs or outputs for function 'Item'.

[Walter Roberson]

It looks like more correct would be

sourceSheet = workbook.Sheets.Item('Sheet1');

[Mauro Colombano]

Thank you Walter for this first suggestion: it works! If you have any siggestion, especially on the topic "destCell.Characters.Item(1).Font.Name = 'Symbol';", it would be really great!