Filter option from excel


#1

How to select the filter for particular column in excel and scroll down to select options.


#2

I prefer using datatables for this purpose.
Do a ‘Read Range’ first and then you can use the datatable.select method to filter the rows you want.
This returns an array of datarows that you can use in a for-each loop.

Yes, there are cases where datatables can’t be generated due to the size of data. you’ll need to use hotkeys in that case.


#3

Data is huge so.I’m unable to do that… plz tell me how to set hot key… is it possible to set since I need to scroll down to select option

.[quote=“akhi_s27, post:2, topic:2787, full:true”]
I prefer using datatables for this purpose.
Do a ‘Read Range’ first and then you can use the datatable.select method to filter the rows you want.
This returns an array of datarows that you can use in a for-each loop.

Yes, there are cases where datatables can’t be generated due to the size of data. you’ll need to use hotkeys in that case.
[/quote]


#4

Hey @kla

How much huge is your data ? for better performance and data handling you should prefer datatable and for your knowledge

According to MSDN DataTable Class “The maximum number of rows that a DataTable can store is 16,777,216”, surprisingly, the page is not showing limitations in terms of MBs

and if your data in a table format then you can use "Filter table " activity fro excel category.

Regards…!!
Aksh


#5

Hi @kla Data Tables is the best preferred option to filter and sorting out the data. how much data it can be u can follow that…

if u want to learn the head keys… you can follow this…

Steps:

  1. Goto A1 and Type that Column Num to be filtered…
  2. Next Select Entire Row by Ctrl+Space
  3. Next Give Alt+Down to filter menu

#6

I used macro to filter the data since I’ve more than 100 columns in my excel and the data use increase every week.


#7

Can able to print selected columns from outputdata Table?


#8

No it will capture entire data without filter… Filtered alone cant be captured in DataTable…


#9

Hi, akhi_s27 ,
Do you have same handbook to help me to understand “how to use datatable.select” ?
thanks very much!
I try my best , but i didn’t write a right code which can run it .