Vb.Net code to fill blank cell with color

Help Studio
, ,
1

image
image959×699 52.2 KB

I have written this vb.Net code i have added namespaces as well but facing the issue of
Unexpected error has occurred during the library compilation process:
The assembly compilation returned the following errors:

  • The type or namespace name ‘Application’ does not exist in the namespace ‘Microsoft.Office.Interop.Excel’ (are you missing an assembly reference?)
2

image

Also getting this error

3

Hey

why are you doing that in that way?

you can easily use the UiPath activities like this example

in your if activity validate that the cell is empty, if so, then lookup the value to retrieve the cell value and the pass that value to the set range color

String.IsNullOrEmpty(CurrentRow("yourColumnName").ToString) Or String.IsNullOrWhiteSpace(CurrentRow("yourColumnName").ToString)

image
image550×781 27 KB

Regards

4

I have 3500 rows and it takes lot of time i need it to process faster

5

Hi @Pooja_Parekh1 ,

Could you replace the value in the 3rd Line, xlWorkbook.Sheets("Sheet1") in Invoke Code Activity to the below :

CType(xlWorkBook.Worksheets("Sheet1"),Microsoft.Office.Interop.Excel.Worksheet)

Let us know if you still receive errors.