process with filtered columns data
process with filtered columns data
bifi
Posts: 2Questions: 1Answers: 0
I would like to calculation with some columns value. The index of columns change dynamically and sometimes i need more columns.
I use rows ({search 'applied'}). .nodes () Cells [colNumber] collection and it works, but more than 2-3 000 records it's too slow.
Is there any other way to process the specificed filtered column values?
thanks a lot
This discussion has been closed.
Answers
The better way is to use
columns().nodes()
rather than picking out the cells yourself.You can still pass in the search 'applied' into columns().
Would you mind posting the code you are using?
Thanks
Tom
perfect, very fast.
thx