MATLAB: Convert Matlab index to Excel index

conversionexcelindex

I have a big matrix with strings and numbers in matlab and saved it as an excel spreadsheet. Now I want certain cells to have a certain color. From this forum I learned partly how this can be done:
clc; clear all; close all;
Excel = actxserver('Excel.Application');
%Excel.Visible = 1;
WB = Excel.Workbooks.Open('C:\Users\XXXXX\Documents\MATLAB\cut and dubbles.xlsx');
WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 10;
WB.Save();
WB.Close();
Excel.Quit();
I know how I can investigate the matrix to get the indices of the cells I want to have colored, but I dont know how I could change a matrix index like (2,5) to an excel index like 'E2' automatically and dynamically. Is there a command for it?

Best Answer

Related Question