Is it possible to strike a cell value in Excel

Help Studio
, ,
1

is it possible to strike a cell value in Excel? i need change the text color to Red and Strike it.

An Excel sheet displays numbers in column D, with text in column E having strikethrough and some text in red color, while column F contains non-strikethrough text. (Captioned by AI)
An Excel sheet displays numbers in column D, with text in column E having strikethrough and some text in red color, while column F contains non-strikethrough text. (Captioned by AI)459Ă—343 2.96 KB

2

Hi @arivazhagan_mathivan
Check this,

Happy Automation

3

@arivazhagan_mathivan,

Yes, this is possible using VBA code. Use Invoke VBA activity and pass this code in a text file. Change the cell address as per your need


Sub FormatCellD3()
    With Range("D3").Font
        .Strikethrough = True
        .Color = RGB(255, 0, 0) ' Red color
    End With
End Sub
1 Like
4

is it possible to strike the cell value?

5

@arivazhagan_mathivan,

Yes, give it a try on static cell and then you can make it dynamic as per need

6

Hi @ashokkarale
I’m facing this error not sure the reason. Can you please help on this.?

This is my workflow

The image shows a UiPath sequence for interacting with an Excel file, where a VBA script is being invoked using specified arguments to format cells by address. (Captioned by AI)
The image shows a UiPath sequence for interacting with an Excel file, where a VBA script is being invoked using specified arguments to format cells by address. (Captioned by AI)536Ă—647 21.5 KB

Error Im getting

The image shows an error message in UiPath indicating that the 'UiPath.Excel.ExcelProcess' type cannot be serialized. (Captioned by AI)
The image shows an error message in UiPath indicating that the 'UiPath.Excel.ExcelProcess' type cannot be serialized. (Captioned by AI)1032Ă—370 16.7 KB

7

@arivazhagan_mathivan,

Looks like you are trying to pass ExcelProcess type variable as an argument in your project. That’s not allowed. Remove that and you should be able to run.

8

Are you using persistence?

9

sorry, Can you please be more specific? im not getting what you are mentioning. I’m not using any variable in the flow. Please help.

The image shows a workflow for automating Excel processes, which opens a specified Excel file, invokes a VBA script from a given code file to format a cell by address, and uses an argument value "D5". (Captioned by AI)
The image shows a workflow for automating Excel processes, which opens a specified Excel file, invokes a VBA script from a given code file to format a cell by address, and uses an argument value "D5". (Captioned by AI)483Ă—638 22.1 KB

10

@arivazhagan_mathivan,

The error isn’t from the current workflow but from another workflows in your project. Check the arguments of type ExcelProcess if any.

11

@arivazhagan_mathivan

  1. Are you usinng any persistent activities or is it enabled in project settings?(something like wait and resume)
  2. Dont use one drive paths for keeping workflows and files being used..better use local path

Cheers

12

Hi @arivazhagan_mathivan

Check the below zip file and let me know if you have any questions.

Apply Red Font and Strikethrough.zip (122.5 KB)

Note: Please change the cell address in Assign activity as required

Output:

image
image198Ă—156 1.7 KB

Hope it helps!!

13

Thanks @Parvathy
It is working.

1 Like
14

You’re welcome @arivazhagan_mathivan

Happy Automation!!

15

Test.zip (21.7 KB)

Hi @Parvathy
I’m using a similar code as yours, but I’m encountering an issue. Could you please help me understand it, if possible?

16

Hi @arivazhagan_mathivan
You are getting error because the argument name use passed in VBA Argument and in text file is different. Change the name in Text file and try running the code.

Regards

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.