Hi, how do I detect if text in Excel has Strikethrough formatting?
I think the easiest way would be by injecting VBA code https://docs.microsoft.com/en-us/office/vba/api/excel.font.strikethrough
I’m not too familiar with macros and VBA… is there another way to do this?
I do not see a simple one, as UiPath doesn’t know how to interact with individual cells (i.e. clicking)
Could you provide a sample workflow and macro? Thanks
Input: cell location, Output: boolean contains strikethrough formatting
All the information needed is in the link provided.
As for UiPath part, you have the documentation here as well as a sample to test it.
Sub TestStrike() If Range("B4").Font.Strikethrough Then MsgBox "Cell B4 is Strikethrough" End If End Sub