Unable to filter the data from the excel

Help
22

Strange

image
image716×179 10.6 KB

1 Like
23

Then that not taking that column that’s why filter datatble also didn’t give us output
So how we got the column name previous
You shared a image with all the names rightly

Cheers @balkishan

1 Like
25

Fine first we need to find the column name and their position
May I know from where we are getting the input
Cheers @balkishan

1 Like
27

Bro, Are you there.
input is coming from the xlsx file.

1 Like
28

Can i have a view on that xlsx file a screenshot
Cheers @balkishan

1 Like
29

yes sure bro, If you see in the 10th line there is type name column.
I am filtering that column only and want the entire data from 11th line till end after filtered.

1 Like
30

Fine
are we good now extracting the data from 10th row

@balkishan

1 Like
31

Yes, In the Read Range I am giving bcz I need the header from line number 10th
and how I get the data in the variable.
)

1 Like
32

Fine

so are we getting the dattable with correct data
cheers @balkishan

1 Like
35

@Palaniyappan I am getting the Data in the Excel Sheet but I get the same data, It’s not filtering the Row…Can you please see…

1 Like
36

Sorry for the delayed response buddy
i think we are lagging with the columnname
we need to check with that
may i know how we are getting the data from that csv, is add headers enabled or disabled

Cheers @balkishan

1 Like
37

Not from the csv bro.
Now I converted into xlsx. So we’re getting data from the xlsx format with enabled headers.

38

Not from the csv bro.
Now I converted into xlsx. So we’re getting data from the xlsx format with enabled headers.

I gave the Range A10 bcz I want to read the data from the 10th Rows and use the filter over there based on the Column Name.

image
image886×274 10.4 KB

1 Like
39

Great
–so hope we are reading the range from 10 with add headers enabled right
–if so after getting the datatable use a writeline and mention like this
Dt.Columns(2).Columnname.ToString
lets check what is the columnname
@balkishan

1 Like
40

same - type column name we’re getting bro.

image
image721×213 12 KB

1 Like
41

Fine
then in the filter datatable mention this in the column field and try once
Dt.Columns(2).Columnname.ToString instead of mentioning as “type”

Cheers @balkishan

1 Like
42

Same value I am getting in the third column(type).

I want to keep only Order & Shipping Services

It gives me all value in the third column…
Approach…
image

43

Fine were you able to see this ORDERS and SHIPPING SERVICEs in this C column
just to cross check whether the column we have used is correct or not
Cheers @balkishan

1 Like
45

@Palaniyappan Please see bro, why the filter data table is not working when everything is fine.

46

wheather I choose the keep or remove option, It not filtering anything, same data it’s giving me as I have in my original excel file.