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:
- Read your Excel Data: Use the “Use Excel File” activity to open your Excel file.
- 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.
- 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.
- Use Filtered Data: Work with the copied/filtered data and proceed with your automation to display it in Google Chrome.
- 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.