How do I fill a group of excel cells with color considering a matrix of type "Cell" that I have in matlab?

5 ビュー (過去 30 日間)
Good afternoon. My problem is the following. I have a series of cell type matrices (which are of variable size according to some input data) that I am putting in an excel using the command "xlswrite" stacking them one below the other and all on the column "A", I leave the code:
fila_exc=fila_exc+NP+1; % Row where the matrix is ​​placed in Excel
Celda_Excel=sprintf('%s%d','A',fila_exc); % The cell where the array is placed in Excel
xlswrite('testdata.xlsx',Ys_c,1,Celda_Excel); % My variable size matrix = Ys_c
The code works perfectly to put my matrices in the excel, however I am looking for each matrix placed in my excel to have a color, without having to use cell ranges, only recognizing the size of my matrix and giving color to the cells originated by said matrix.
Is there any way to get this? thanks for your help

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

製品


リリース

R2017b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by