How to Identify strikethrough text

[Samuel_Mwarabu]

How can I successfully approach a use case where the automation has to read text and identify any strikethroughs in the notes so that to either exclude those ones or still report them in the output but show the strikethrough

[Gokul001 (Gokul Balaji)]

Hi @Samuel_Mwarabu

Welcome to UiPath community

check out the thread

Filter data By Strikethrough In Excel?

Hey @Aaron_Ko For sure. I’ve created a simple VBA script for you, which does the job (checks if there is a Strikethrough). If yes, write “1” in the next column. We invoke it with an “Invoke VBA” activity inside an “Excel Application Scope” activity. Everything is attached. The simple Excel dataset (attached as Book1.xlsx) [image] The VBA code to invoke (attached as StrikeThrough.txt) Sub StrikeThrough() For n = 1 To Rows.Count If Range("A" + CStr(n)).Font.StrikeThrough Then Range("B…

UiPath Excel Change Font Name, Size, Style , Script,Strike through,Color, Underline the cell range

Regards
Gokul