How to color excel cell backgrounds with Matlab?
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
Image Analyst
il 17 Feb 2016
Modificato: Image Analyst
il 17 Feb 2016
Did you try this:
Excel.Worksheets.Item(1).Range(cellReference).Interior.ColorIndex = cellFillColorIndex;
Vedere anche
Categorie
Scopri di più su ActiveX in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!