MATLAB: Changing excel’s cells properties from Matlab

activexcellsexcelprogrammingproperties

Hi, is it possible to change a cell property? for example, I want to write some data from matlab to excel, can I change the format of how it is written? as cell's color, type of letter, style, alignment, etc

Best Answer

Sure, just use ActiveX and you can do whatever you want. I've used it to put borders on cells, add comments to cells, auto-size columns, transfer worksheets to another workbook, etc. Look up ActiveX on the Mathworks site or the Answers forum. Lots of examples are online, plus the Microsoft site has an Office developers center where you can learn more.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Excel’s named range through Matlab

Hi,

this is not possible using xlswrite. You have to do that programatically afterwards using COM/ActiveX, e.g.

ex = actxserver('excel.application');
ex.Workbooks.Open(fullfile(pwd,'Mappe1.xlsx'));
ex.Range('A1:C3').Name = 'RangeName';
ex.ActiveWorkbook.Save
ex.Quit
ex.release

So do a xlswrite to write down the data and afterwards create the named ranges.

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Excel’s named range through Matlab

Related Question