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


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

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 :))


Hello @Seonyong

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