Filter Out Cell Value

[AsitabhaDeb]

Hi Expert,

In the attach screenshots I would like to Filter Out Only "KB Order" type.
I have created custom BO under Excel VBO. when I am enter expression in "CriteriaToField" all the data are filter out from excel.
Can you please help me out .
In the excel Order Type is Fileld# - 2
For eg.

Order Type
KB
OR
ZSTK
I need to filterout only KB from excel. as this is huge excel file "Filter Collection" will not work.
Attachment for ref.

------------------------------
Asitabha Deb
------------------------------

[Vamshi_KrishnaD]

Hi

You need define the range and filter either in code stage you have to write

or use extended ms excel vbo - Auto filer


------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------

[MiguelCarrillo]

In order to use the custom action that you create. You must select first the range of cells of your sheet and then appy the filter.

To select the range, you could use the action Select that its include within Blue Prim.
And then apply your custom action that you built.

If you have any doubts i could help you.

------------------------------
Miguel Carrillo
------------------------------

[AsitabhaDeb]

Thanks Migual,

Its working fine now.

------------------------------
Asitabha Deb
------------------------------