I would like to set background color for the datarow

i would like to set color in the datarow and then paste it to excel.
i do not want to paste it first and then color it.
is there any way to achieve this??

Hi @Seonyong
Check the below post

Thanks
Ashwin.S

Continuing the discussion from How to set color in excel:How to set colour in excel for Dyanmic column Range

@aksh1yadav
how to Define Range in Set Range activity if My data exist till Coumns AC, AD,AE and so on…Column range is dynamic

Hey @Sparks811

just take Datatable.Columns.count and use my code for column name mapping(Attached in below Existing Thread :))

Regards…!!
Aksh

Hello @Seonyong

I’m also stuck with the same problem. Did u get the solution.