18-09-23 03:44 PM
Hi Team,
I'm facing an issue with filtered data in Excel. What I want to do is move the filtered data to another column. What's the best approach or action for this?
18-09-23 03:50 PM
Hi Ace Rigor Santos,
Filtering will reduce the no of rows in excel.
Are you looking to create a new worksheet based on filtering?
I can think two approaches but it might be done different ways.
1) Read the data from excel and get the data as collection and use filter action in collection manipulation and write the data back to excel
2) USe filter in excel itself with out saving the changes read the data as collection from the filtered data and write back that collection to excel
18-09-23 04:03 PM
Hi Harish,
I've applied the filter. My next step is to move the data from column AE to column AG and replace it with 0. I initially tried using the 'Copy and Paste Worksheet Range' action, but I encountered an error. I then attempted the 'Select, Copy, and Paste' action, but I'm still getting an error
18-09-23 04:18 PM
Hi Ace Rigor Santos,
In general if you use the code stage to filter the excel it will only give the filtered data but based on the screenshot provided it is giving filter icon at the column name which means it is filtered manually is that correct? , The same option is not available in code. I have tried to replicate manual filter vs code in the past having trouble doing that.
I think the issue you encountered might be due to mismatch between the rows the rows copied and the original rows is different that might cause the issue.if you use the code stage to filter you may not see the error in copy and paste action.
But if you are looking only updating the value based on the column 'AE' I would write formulae instead of trying to copy and paste it.
18-09-23 04:25 PM
Hello,
Another possibility that can be flexible is the use of VBA script to support execution through the code stage, if you can't achieve it through the utility.
Regards,