Excel Filter and upload to a new excel sheet
Hi
i have a set of data in the excel.
I need to filter a column and save the filtered excel data in to a new sheet.
how it can be done.? can anyone help me on this.
Posted: 1 year ago
We'd prefer it if you saw us at our best.
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.
I don't think you can use the Excel column filter but you can use the connector and a stringutil to filter manually http://help.openspan.com/80/Components/Microsoft_Excel.htm