How to apply color to excel column

[T_Y_Raju]

How to apply color to excel columns
i want to apply pale yellow color to the excel column
please let know the process

[lrtetala (Lakshman Reddy)]

Hi @T_Y_Raju

Can you try the below

Excel.Sheet("Sheet1").Range("A1:A"+Excel.Sheet("Sheet1").DataTableValue.RowCount.ToString)

Cheers!!

[T_Y_Raju]

@lrtetala

Excel.Sheet("Sheet1").Range("A1:A"+Excel.Sheet("Sheet1").DataTableValue.RowCount.ToString)

how can i do using workbook activity

[lrtetala (Lakshman Reddy)]

@T_Y_Raju

How about the following?

ColorTranslator.FromHtml("#FFFF00")

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The extr…

Cheers!!

[mukesh.singh]

you can create the VB scrip code for this.