How to set Excel cell color to from Matlab using R1C1 range notation?

5 次查看（过去 30 天）

显示更早的评论

Don Kalinich 2020-1-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502499-how-to-set-excel-cell-color-to-from-matlab-using-r1c1-range-notation

编辑： Don Kalinich 2020-1-29

在 MATLAB Online 中打开

This question is related to this one:

https://www.mathworks.com/matlabcentral/answers/3352-how-to-set-excel-cell-color-to-red-from-matlab

And the question is, can the Range be specifed in R1C1 notation rather than A1 notation? And if so, how?

WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 3;

I have tried the following with no success:

WB.Worksheets.Item(1).Range(cells(i+1,j+1),cells(i+1,j+1)).Interior.ColorIndex = str2double(outTblColor{i,j});

Thanks for the help.

2 个评论
显示无隐藏无

Allen 2020-1-29

在 MATLAB Online 中打开

As alternative to trying to work with R1C1 notation (never was successful using this via ActiveX), you could use the xlscol function (FileExchange) to convert R1C1 input to the standard A1 notation.

https://www.mathworks.com/matlabcentral/fileexchange/28343-column-converter-for-excel?focused=5156839&tab=function

The following code segment shows one way of converting your i and j variables to row and columns text, respectively.

A1notation = sprintf('%s%s',xlscol(j),i+48); % Adding 48 to i corrects for ASCII values of numeric characters.

Don Kalinich 2020-1-29

Thanks! Writing something like xlscol was going to be my next step. I implemented Mr. Crosby's xlscol and it works like charm.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

MATLAB

Community Treasure Hunt

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

Start Hunting!

Translated by