How to extract filtered data from Edit Grid to Excel in UiPath Apps

Help Apps
,
21

@tilarapiyush

Ideally whatever is there in datatable as column would be exported..can you show what you have done to understand the issue

Cheers

22

I set value of DT in MainPage.

The image depicts a software interface showing an expression editor window for configuring rules on a "load" event in MainPage, featuring code that builds a DataTable with various DataColumns including strings for attachment details and email status. (Captioned by AI)
The image depicts a software interface showing an expression editor window for configuring rules on a "load" event in MainPage, featuring code that builds a DataTable with various DataColumns including strings for attachment details and email status. (Captioned by AI)1277×475 59 KB

The set value in button.

The image shows a software interface with an expression editor displaying code that selects data from a data source and stores it in a variable labeled "DT". (Captioned by AI)
The image shows a software interface with an expression editor displaying code that selects data from a data source and stores it in a variable labeled "DT". (Captioned by AI)1253×374 39.4 KB

23

@tilarapiyush

then ideally every column which is present in select statement would come..the structure would not change

cheers

24

If “PO Number” column is completely blank, this column is not getting exported to excel.

The image shows a table listing purchase orders with columns for PO Number, PO Status, PO Status Reason, and Sales Org, displaying two entries with the status "In Progress" and reason "23-More than one Custome..." under the UK01 sales organization. (Captioned by AI)
The image shows a table listing purchase orders with columns for PO Number, PO Status, PO Status Reason, and Sales Org, displaying two entries with the status "In Progress" and reason "23-More than one Custome..." under the UK01 sales organization. (Captioned by AI)854×334 3.24 KB

25

@tilarapiyush

How are you exporting the data?

to verify if it is present in datatable dt..try to use show message after the set value in button and check dt.rows(0)("po Number").ToString.if this populated then it means the data is being saved in dt but while writing to excel you are removing or so…check the same

cheers

cheers

1 Like
26

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