Filter Data Table Display Nothing on the Excel

Help Activities
, ,
1

Hello guys, I would like to ask why it displayed nothing on the Excel file after filtering the data table and using the write range in another Excel file. Does anyone know the reason? However, I can show all the data without using the filtering function.

image
image494×614 16.1 KB

image
image438×760 21.4 KB

image
image1312×163 6.8 KB

image
image

2

Hi @CHAN_Hiu_Fung_Victor_Stud

Can you share the Input file and the conditions required for filteration?

Regards

3

Thank you for your help. Here is the input file. I only want to show the column App# that same as the AppNum I input. However, after filtering the data table, it shows nothing on the output Excel file.
Sample.xlsx (9.8 KB)
image

4

Hi @CHAN_Hiu_Fung_Victor_Stud

Please give me sometime I will update you regarding this issue.

Regards

5

Thank you very much!!!

6

Hey @CHAN_Hiu_Fung_Victor_Stud
Here you can find working solution:
BlankProcess74.zip (10.1 KB)
To achieve it I used LINQ:
dtData.AsEnumerable().Where(Function(row) row("App#").ToString = inputAppNum).CopyToDataTable()

image
image988×505 24.2 KB

I hope it helps :slight_smile:

1 Like
7

Thanks very much !!! I will try this later.

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.