"filter" excel

Help StudioX
,
1

Hello everyone! I hope you’re all well. I’m trying to get to grips with Ui Path Studio X, but I had a question. I want to use the ‘filter’ activity on excel to search only one row based on the data in the other columns to display it on google chrome. My ‘robot’ works well with this activity but deletes all the other rows in the table. Is there an activity that I can add so that my Excel table is intact after launching the robot?

Forum Engagement Daily Reports
2

@Julie2,

Welcome to the UiPath Community :tada:
Can you share exact logic or activities you have used for this so can assist more.

Thanks,
Ashok :slight_smile:

3

You can handle this issue by using the “Copy/Paste Range” activity in UiPath Studio X to copy the filtered data to another sheet or range, rather than modifying the original data directly. This way, you preserve the original table while working on the filtered data.

Here’s how you can do it:

  1. Read your Excel Data: Use the “Use Excel File” activity to open your Excel file.
  2. Filter Data: Use the “Filter” activity on the data table to get the specific row(s) you want to display in Google Chrome. Instead of filtering directly in Excel, you can store the filtered results in a new data table.
  3. Copy the Filtered Data: After filtering, use the “Copy/Paste Range” activity to copy the filtered data into a new sheet or range, without modifying the original data.
  4. Use Filtered Data: Work with the copied/filtered data and proceed with your automation to display it in Google Chrome.
  5. Optional - Cleanup: If needed, after you finish your automation, you can delete the sheet or range where you pasted the filtered data, so the original data remains intact.

This approach keeps your original data in Excel unchanged, while still allowing you to work with the filtered data.

1 Like
Forum Engagement Daily Reports
4

Thanks a lot, I’ve done it. What do I have to do to delete the extra sheet I’ve created?

5
  1. Use the Excel Application Scope to open the file.
  2. Inside the scope, use the Delete Sheet activity.
  3. Specify the name of the sheet you want to delete in the SheetName field.

This will remove the sheet without affecting the rest of your workbook.

6

Ok, thank you so much

7

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