How to read range with colors and do write range with colors

Help Activities
, ,
1

i need to read colors cells and write it to new excel file

2

@Gomathi_Ganesan

If you want whole sheet exactly or a range…then use copy sheet or copy range activity which will copy the formatting as well

Or you have get and set the color activities

https://docs.uipath.com/activities/docs/excel-get-cell-color

https://docs.uipath.com/activities/docs/excel-set-range-color

Cheers

3

@Gomathi_Ganesan
Or you can do this by opening the excel provide the hotkeys Using ALT+ + keys like

image
image971Ă—531 33.8 KB

main shortcut is Ctrl+G then use typeinto

4

Ctrl g then i have given the range then what to do?

5

When i do copy paste range cells are referring the sheet 1 so what to do

6

can you provide screen shot of the copy/paste range activity how you have configured

if possible flow as well how you are doing

Regards

7

Hi @Gomathi_Ganesan

  1. Use a “For Each Row” activity to loop through each row in the DataTable.
  2. Within the “For Each Row” activity, use a “For Each Column” activity to loop through each column in the current row.
  3. Within the “For Each Column” activity, use the “Get Cell Color” activity to get the color of the current cell.
  4. Write the cell color value to a new Excel file using the “Write Cell” activity.

Thanks!!

8

For giving color you have to color with VBA macro activity. Ask chat gpt it will give you proper code for coloring. Just invoke it with proper inputs.

9

@Gomathi_Ganesan

You can change the sheetname as you want

cheers

10

If possible could you please share workflow for this logic

11

Ok will try

12

Okay sure will do and let u know

1 Like