How do I overwrite cells with a different value?

Help
1

HI.
I am struggling to work out how to do the above.
Basically, if a cell in column G (Service downtime) in the attached, contains a 0, I need to change the text to read N/A. And if it contains a 1, I need to change it to a 1.

The amount of rows that this occurs in is dynamic also.

Could someone who is more proficient, provide me with an example please?

IN PROGRESS - Test.xlsx (9.3 KB)

2

Use Excel Application Scope
In that Give path of the file
Then in that use Read Range ------Give Sheet name and Set output as DT
Then use For Each Row -----Give input as DT

Then in Fir Each Row use If Condition say
If row(“Service downtime”).ToString.Trim=“0” -----Here u can use Contains Condition instead of “=”
Then Assign
row(“Service downtime”)=“N/A”
Else Again Use IF condition
IF row(“Service downtime”).ToString.Trim.Contains(“1”)
Then Assign
row(“Service downtime”)=“1”

I have share both condition for understanding
After that use Write Range outside the For Each Row
In that give Sheet name and Datatable as DT
row(“Service downtime”)

3

Thanks for this.
I assume I must be doing something incorrectly as I am getting an error in ‘For Each Row’ on the output which is ‘Value of type ‘System.Data.DataTable’ cannot be converted to Integer’
Any suggestions where I am going wrong?

4

Hey you are converting Datatable to integer can you show me what you did in assign

5

I’m not trying to convert it no.
It will either read 0 or 1 when the sheet is opened and I need to change 0 to N/A and 1 to YES.

I am probably doing something completely wrong. I have attached the screenshotScreenshot 2020-10-20 101123

6

where did you get error

7

It’s in the ‘output’ on the For Each Row bit

8

can you share me workflow

9

Main.xaml (10.2 KB)

10

You are getting error coz you give index as Datatable output

image

11

remove this you dont need this

12

Awesome. I knew I had done something wrong. That works a treat now. Thank you so much

13

Great !
Please mark it as solution and close this topic

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.