How to color excel cell backgrounds with Matlab?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a matrix which I would like to input in excel and I would like to color every cell which is between certain range. And I know that I can do that by using ActiveX but all the examples I found didn't help me too much.
To found the cells within my range I've written a code like below and I would like to color those cells in MyMatrix which are 1 (ones) in IndexMatrix.
Is there a good way to do this?
MyMatrix=rand(5)
Rows=size(MyMatrix,1);
for i=1:Rows
idx = MyMatrix(i,:) >= 0.2 & MyMatrix(i,:) <= 0.5;
IndexMatrix(i,:)=[idx];
end
IndexMatrix
[filename pathname] = uiputfile({'*.xlsx'});
FileNameString=strcat(pathname, filename); %Same as FullFileName
myfile = filename;
xlswrite(myfile,MyMatrix);
0 Kommentare
Antworten (1)
Image Analyst
am 17 Feb. 2016
Bearbeitet: Image Analyst
am 17 Feb. 2016
Did you try this:
Excel.Worksheets.Item(1).Range(cellReference).Interior.ColorIndex = cellFillColorIndex;
1 Kommentar
Siehe auch
Kategorien
Mehr zu ActiveX finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!