Read Range with 'Use Filter' did not read all filtered data

[meghna.b.das]

Hi,

I used Read Range activity with ‘use Filter’. My workbook has a column of dates which i filtered using excel. However, the read range activity isn’t reading all the filtered data.

[Nithinkrishna]

Hey @meghna.b.das,

It should actually read only the filtered data from excel.

Any error you face or only the deviation in output data ?

Thanks

[meghna.b.das]

Hi, it’s only the deviation in output

[Nithinkrishna]

Is it possible for you to share the xaml and data file…

Thanks

[meghna.b.das]

Hi,

Please find attached the file to read from - Test Data.xlsx and the file to write to - Output.xlsx
Also please find attached the XAML file.

The Test Data file is filtered for last month’s data in the “System Booking Date” column.
Appreciate your assistance with this.

Prepare data set.xaml (12.3 KB)

Output.xlsx (34.2 KB)

[meghna.b.das]

Hi,

Please find the excel workbook attached from which I am trying to read the range.

Test Data Trimmed.7z (6.9 MB)

[Nithinkrishna]

Hey @meghna.b.das,

It’s running fine with filtered output data when I tried.

Could you please check once

Thanks

[meghna.b.das]

Hi,

It’s not reading all the data. It read and pasted only 294 rows in the Output excel whereas the Test data excel has 71044 rows after filtering.

[Nithinkrishna]

Hey @meghna.b.das, Yes it was due to the range manipulation using count which was deviating.

So I just tweaked the solution for you. Could you please check and confirm the output.

PFA - FilterData.zip (8.5 MB)

Check the output file, Output_Updated_221220_095501.xlsx in the project folder.

Hope this helps

Thanks

[meghna.b.das]

Hey @Nithinkrishna. Thank you for the solution! Can you share with me a screenshot of your UpdatedDataSet workflow? The activities aren’t loading properly due to my UiPath Studio version.
Many thanks again!

[Nithinkrishna]

Sure, Here it is…

Remove data column has the index value for the two columns to be ignored.

Which is index 4 & 8 (5th and 9th column)

Thanks

[meghna.b.das]

Thank you @Nithinkrishna!