How can I detect a change in cell value from a series of an excel sheet and then Highlight the change through a script

2 次查看（过去 30 天）

Sanjeev Pareek 2021-7-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/869718-how-can-i-detect-a-change-in-cell-value-from-a-series-of-an-excel-sheet-and-then-highlight-the-chang

评论： Sanjeev Pareek 2021-7-2

I have a large excel sheet which consists of strings and Integers. I have read the sheet through 'readtable' but How can I compare a cell value(column wise) from it's previous cell value and Highlight the cell by a particular colour?

Any Help would be appreciated.

2 个评论
显示无隐藏无

dpb 2021-7-1

Look at diff() to find differences of given variable -- remember the output array is one less in length than the input array in finding the actual array location.

As for changing formatting inside Excel, that's a job that has to be done with ActiveX/COM

There are sample routines that have been posted in the past although I didn't think to save a link -- if somebody else doesn't get there first, I'll try to come back and attach the utility routines code.

Undoubtedly is something at FEX, too,

Sanjeev Pareek 2021-7-2

Using diff() can be a option, but won't compare work as I am unable find any command for integer compare like strcmp.

Can you shed some light on this, regarding changes in excel, I have explored actserver and the script provided by Jiro, but then changes can happen in hardcoded cells, though I need generalised which is not working with "WB.Worksheets.Item(1).Range('H8').Interior.ColorIndex = 3;" as can be seen a particular cell colour can be changed, but I want to generalise it, any ideas on that will be helpful along with above elaboration.

Thanks

请先登录，再进行评论。

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