MATLAB: How to embed image and text using matlab in excel sheet

activexexcel

I have used the previous documents help to embed multiple images in excel sheet.

Now I want to embed information of PSNR value beside this image in excel sheet.

Can I know how to embed text in excel using ActiveX ?

Best Answer

See attached ExcelDemo that does exactly that.

As a bonus, I'm also including a demo that lets you put a formula into a cell of the workbook.

Related Solutions

MATLAB: How to speed-up the ”write, read and save” of an excel file from matlab

use ActiveX to write and read instead of xlswrite and xlsread respectively.

MATLAB: How to set Tab color of an excel sheet using Matlab command

The below command i used and it worked for me

 % Excel = actxserver('excel.application');
WB = Excel.Workbooks.Open(fullfile('Sample.xls'));
% Set the color of Sheet 1 to RED
%'Red'--> give the proper color index ex: Red = 3
%'SheetNo'--> ex: Sheetno = 1
WB.Worksheets.Item(SheetNo).Tab.ColorIndex = Red;

Best Answer

Related Solutions

MATLAB: How to speed-up the ”write, read and save” of an excel file from matlab

MATLAB: How to set Tab color of an excel sheet using Matlab command

Related Question