Hi,
How can I highlight a cell of Excel sheet using MATLAB?
Any help would be appreciated.
Regards,
Morteza
http://mortezash.blogfa.com/
You should work with Excel via ActiveX technology. Look at this example
http://www.mathworks.com/matlabcentral/answers/94822-are-there-any-examples-that-show-how-to-use-the-activex-automation-interface-to-connect-matlab-to-ex
As it has been said you should consider using ActiveX. Check this link:
http://www.mathworks.com/matlabcentral/answers/102070-how-do-i-write-data-to-an-excel-spreadsheet-with-a-custom-cell-background-color-and-custom-font-colo
Hello,
@ Vidhi: I want to write the results as a table in Excel sheet via MATLAB programming (using xlswrite() function) at the first step. Then, I would like to highlight (or make it bold) a specific row of this table by writing a code in MATLAB. Just this!
@ Vsevolod and Pedro: Many thanks for your worthwhile answers but unfortunately, I cannot open the mathworks pages and thus I would be grateful if you briefly explain how I can use ActiveX and find a solution for this problem.
Regards,
Morteza
@Morteza
I attach the above mentioned example from Mathworks.
Look at it - the main idea - You have access to all properties and methods of Excel objects. If You don't know the name of the property - You can record macros in Excel and see it.
Hi, below I copied an example (from one of my book in Chinese).
This example shows how to open excel server, active one sheet and select a cell, output a picture to a cell, and draw graphs using data in excel.
Your task can be done similarly. Hope it helps.
Btw, if you just don't know which children-object of a specific parent you should use, you can use get function to list all their features. Also, you can simple finish your task first directly using excel but in the same time you should record the macro in excel. then you can see the VB codes of the macro corrponds to the processes you've done. And finally you can just type codes in MATLAB according to the VB codes.
note #2: the following codes can work well in MATLAB R2014b and newer version. I don't check it using older versions.
note #3: in following codes, the annotations are give in Chinese. sorry that I did not translate them. But you can just leave it and go through those codes.
Hope it helps.
regards,
Peng
[code]
%% 创建新的工作簿并打开
he = actxserver('Excel.Application');
hw = he.Workbooks; % 或者使用hw = get(he, 'Workbooks');
hworkbook = hw.Add; % 或者使用hworkbook = Add(hw);
set(he, 'Visible', 1);
%% 激活Sheet1页
hsheets = get(hworkbook, 'Sheets');
hsheet = Item(hsheets, 1);
%% 示意固定区域的选择
hrange = Range(hsheet, 'B2');
hrange.Select;
hsheet.Paste;
%% 向Excel中输出图形结果
% 首先绘制一幅图
ezplot('x^2 - y^2 = 1');
set(gcf, 'Units', 'centimeter', 'Position', [5 4 8 5]);
% 调用hgexport函数将图形导入到剪切板中
hgexport(gcf, '-clipboard');
close all
% 选择粘贴区域
hrange = Range(hsheet, 'A1');
hrange.Select;
% 粘贴图形
hsheet.PasteSpecial;
%% 调用Excel绘图功能
hdata = Range(hsheet, 'A1:A5');
% 新建图表
hchart = hsheet.ChartObjects.Add(0, 0, 200, 100).Chart;
% 设置绘图数据来源
SetSourceData(hchart, hdata);
% 设置图表类型
hchart.ChartType = 'xlLine';
[/code]
Use something like this to get the cell object - using ActiveX
exl = actxserver('excel.application');
exlWB = exl.Workbooks;
exlFile = exlWkbk.Open('C:\test.xlsx');
exlS1 = exlFile.Sheets.Item('Sheet1');
data_range = 'A1:A10';
rangeObj = exlSheet1.Range(data_range);
cells = rangeObj.Cells;
dispFormat = cells.DisplayFormat;
cellstyle = dispFormat.Style;
- Badges
- Science topic