Hi,
I have an Excel File with up to 100,000 rows that need to be split it up.
I need to filter the collection based on values in a column.
These same values are added to their own individual workbooks. (Usually 10-12 workbooks in total)
Looping through the collection is not optimal.
Is there possibly another way
Thanks in advance.
I have an Excel File with up to 100,000 rows that need to be split it up.
I need to filter the collection based on values in a column.
These same values are added to their own individual workbooks. (Usually 10-12 workbooks in total)
Looping through the collection is not optimal.
Is there possibly another way
Thanks in advance.