Hi, I am extracting excel file from web report. After extract, require to exclude one of the columns with criteria. Example ColumnA <> 'sample'
I manage to use Utility Collection --> Filter Collection. Then I use MS Excel VBO to write the collection and save it after filtered.
Is working fine for smaller files bout 1000-3000 rows. It crash/hang files more than 20,000 rows.
Is there any other method to filter out and save it?
I manage to use Utility Collection --> Filter Collection. Then I use MS Excel VBO to write the collection and save it after filtered.
Is working fine for smaller files bout 1000-3000 rows. It crash/hang files more than 20,000 rows.
Is there any other method to filter out and save it?