|
aplotnikov
Germany
169 Posts |
 Posted - 04/09/2022 : 4:43:00 PM
|
Hi JimThieser,
there are at least two possibilities - you can use either the wxt-X-function or the worksheet filtering.
In the first case you will get the list of indexes, in the second case you can simply read the filtered data to a string array and then assign the values (after conversion to numeric format) to a dataset. If you try to assign the filtered data directly to a (numeric) dataset you will get an array of the filtered numeric values but with empty entries for hidden rows, that is very inconvenient. If you use string array, you do not need to know indexes at all. And it works relatively fast.
This difference in assignment of filtered values exists in the most recent version, I have not checked previous ones.
Alexei |
 |
|
Use Values of a column as extract filter
