Not able to write "Validate" Row by row

[Sam_H]

Hi All

after Validating data its not able to write Validated in AU column in excel

[Gokul001 (Gokul Balaji)]

HI @Sam_H

!) Use Read Range activity | Store it as DtRead

2. Use For each row in Data Table activity

3. Inside the for each row Use Assign activity

Currentrow(ColumnIndex) = "Vaildate"

4. Outside the For Each row in DataTable Use Write range activity

Regards
Gokul

[Gokul001 (Gokul Balaji)]

HI @Sam_H

Check out the XAML file

WriteStatusForEachRow.xaml (6.7 KB)

Regards
Gokul

[Sam_H]

@Gokul001 Do i Need to put ant Cell Range

[Gokul001 (Gokul Balaji)]

No need to any range in the cell Just use "" @Sam_H

[Sam_H]

@Gokul001 Thankyou its working

But i’m Not able to filter it for line description and Need to Add “Checked” in Column I

[Gokul001 (Gokul Balaji)]

Hi @Sam_H

For this can you create a new topic for this issue. Kindly close this topic by mark as solved.

Regards
Gokul

[Sam_H]

Sure Thankyou