How to select an Excel column for Format Cells Activity Range

[D_Okthree (Dof)]

Hi Experts,

I have a question regarding Excel Format Cells activity properties.
I want to change cell format for a table column in Excel file. For example:

Name | Date | Total

Dave | 01.08.2023 | 60
Suzan | 17.09.2023 | 100
Emma | 05.10.2023 | 40

The part that I want to select in Format Cells range is column “Total”.
How should I select that particular range in the Format Cells activity’s range?

Please advice.

Thank you.

[supriya117 (Supriya Allada)]

Hi @D_Okthree

In format cell activity, give range as "C:C"

[37324519]

use write cell workbook
that functionality we ask for you to specify the location of the workbook its name and the range you want to use it in

[lrtetala (Lakshman Reddy)]

Hi @D_Okthree

Try this

Excel.Sheet("Sheet1").Range("C:C")

[37324519]

[Gokul001 (Gokul Balaji)]

Hi @D_Okthree

Check out this tutorial for more details

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Regards
Gokul