Update a Cell in Filtered Output using DataTable

[vaibhav.lal]

Hello Experts,

I am struggling to get this thing working. I have a huge excel sheet which I need to process. I am filtering it and saving the visible rows in a DataTable. Now I wish to update one of the cells, based on the filtered rows with a value. How do I get the Row number of the filtered rows? And how I can use Write range or other option to achieve this?

[yedukondaluaregala]

@vaibhav.lal Welcome to Community!!

to know the row index you can use lookup range activity based on particular value.

and to write the any value in that particular cell you can use write cell activity.

If possible share input and output file with sample data.

Happy Automation!!

[ashokkarale]

@vaibhav.lal,

Instead or reading data into a datatable and then filter it and then write it back, do this:

1. Open the Excel file
2. Add filter as per your condition
3. Update the desired cells of visible rows

[vaibhav.lal]

Thank you @yedukondaluaregala.
Unfortunately, I cannot share the sample data as it has a lot of customer sensitive data.
I am trying to use the write cell value, however I need the row number of the filtered row which I am struggling to fetch.

Thanks

[vaibhav.lal]

Hello @ashokkarale,

Thank you for the advice. How can I use the visible rows in write cell method?
Sorry, if its a basic question. I am newbie in StudioX.

Thanks

[yedukondaluaregala]

No need to exact your data you can create a excel with other data.

Anyway follow below steps

1.read your excel
2.use looup range activity
3.from the output of lookup range activity you can the cell index
4.use write cell activity

Here you are filtering the data but even you applied filter or not the row index wont change.
you know specific value which has present in the cell then you can follow these steps.

[ashokkarale]

@vaibhav.lal,

Try this way.