Write cell inside for each of filter data table from Excel File , inside if condition of Element exist

Help Studio
, ,
1

I want to update excel cell for column X based on whatever the result comes in for Column Y.

See flow below:

Read Excel file
Filter Excel File and get only Column A, P, T
Want to process each row from column A
IF column A process sucess - then update Excel column T(Status)'s row for the same row of A (A2=T2)
IF Fail, update excel column T2 .

I am confused in writing the range as I don’t know how to get cell number to update value.
Thanks

2

Can you share your excel file?

3

Hello,

Please see attached sample file and the steps I mentioned inside Excel File.

Let me know if you need anything.

Thank you So much
Sample.xlsx (32.8 KB)

4

@PALKUMARI_PATEL
There is no data in Column T As per your Condition.

5

Yes, Correct and Thanks.

I’ve solved this.

6

Hey I solved it but for that lookup range I’ve to open Excel Each time which might cause an issue because I have multiple records. Is there any way that I can update cell records without opening Excel?

Current Workflow :

  • Opening Excel
  • Used Lookup Range Activity
  • Used write cell Activity.

@ushu IF you can help here . Thanks in advanced.

7

Use Workbook read range instead of Excel application scope will not open Excel Every time.

Let me know if you have any other requirement.

8

But I am using Lookup Range activity to get those values and using the output of lookup range in Write cell activities Range.

So, If I use workbook activity then how should I get the values or how should I use lookup range ?

9

Uncheck visible property of Excel application scope, It will not open your excel everytime you are using lookup range or write cell activities.

Hope it helps.

Regards,
Saloni

1 Like
10

Hello @sb001 Perfect solution. Thats Working and thank you so much for your help.

11

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