Identify Last column value in an excel column

Help Activities
1

HI Friends,

I have an excel sheet, it has multiple rows and columns. I have a date column ‘J’. In that I want to identify the yesterday’s date column value. I am unable to get the last column value range in J.

image
image1836×722 96.5 KB

Here there are multiple DateTime values on the same day(07/10/2020 HH:MM:ss) with different timestamp.
Now I want to get the cell value range of the last column**(7/10/2020 19:19)** which is J6555 .

PLease suggest me how to get the cell range of that particular value. in the belowscreenshot ,i want to get the range value of J column which is J6555

image
image1132×716 66.5 KB

Thanks in advance!

2

you can identify using data table row count.

3

oh. So with that, May I get the direct cell range of the last column value in J which is J6555

4

yes correct, are you going to use read range (Excel or workbook) activity ?

5

I’m using Excel bro.

6

My main output is i want to check the cell range value of the previous day datetime stamp. In my file that I shared , it was on 8th Oct file. So now I want to go to the previous date time stamp column which is 7/10/2020 19:19…then identify the cell range and then paste my data of 8th october values in the column

7

image
image1434×854 104 KB

In the above mentioned file, I want to copy the data for only 08/10/2020 date…

Pls suggest me how to get only 8th oct data

8

@eshwarsai_ks

You can use Filter Datatable and give the condition as your date

and you can get the results

Hope this helps you

Thanks

1 Like
9

Thank you @Srini84 May I know can we fetch the data from filter and save it into list? because filter may have new values in the future. How to make use of the robot to automatically take the new values from the filter and loop it for the new values?

image
image1399×632 65.3 KB

From the above image,currently there is only one option…if they add more filter values , how to get that values and loop through filter values?

Thanks in advance!!

10

@eshwarsai_ks

For knowing the new values or old values you need to maintain a identifier like if you process that record make a column of Status and give as Completed, In that way you can identify which is new and which is completed

Hope this helps you

Thanks

11

May I know how to fetch the filter values and loop it bro?

12

@eshwarsai_ks

Filter datatable you have to output to a datatable

Let say DT1 → DT2

The use For Each Row activity to loop into DT2

This is the one you are looking for?

Thanks

13

No @Srini84. The filter values for the column A. Currently I have used filter data Table activity and manually mentioned if the column value contains IT, then do the process.

Like wise they may add more values to the filter. In that case how the robot will loop one by one based on filter values?

image
image1085×634 61.4 KB

14

@eshwarsai_ks,

To Identify the last column and row. you can use the below activities.

Thank you
Balamurugan.S

1 Like