Is it Possible to write the table content from UiPath apps to an Excel file?

[Kathirvel_Saminatha]

1.I have a table in UiPath apps, with the values. Now I want to write those data into an excel file.

[Anil_G (Anil Gorthi)]

@Kathirvel_Saminatha

You can trigger a process and then send the data as input to process and write to excel

Cheers

[Kathirvel_Saminatha]

Yes I tried…
I created an in argument in studio I binded the argument with that table. While Execution it is showing an error(:- Object Ref not set to an instance of an Object)

[Anil_G (Anil Gorthi)]

@Kathirvel_Saminatha

Please check the value binding properly

As per error the data is empty or null

Cheers

[Kathirvel_Saminatha]

This is an image for your referece

[Anil_G (Anil Gorthi)]

@Kathirvel_Saminatha

Is the direction of the argument set propwrly?

Cheers

[Kathirvel_Saminatha]

I gave In Direction

[Anil_G (Anil Gorthi)]

@Kathirvel_Saminatha

Now I get it …it is the selected value binding…but not thw whole table which it displays…if you select any row and then trigger it would bind the values

Cheers

[Kathirvel_Saminatha]

How to write the whole table into an excel? Kindly give me any suggesstion

[Arvind_Kumar1 (Arvind Kumar)]

@Kathirvel_Saminatha ,

You can’t pass table/object to process. Current process argument with apps support only generic plain value.

So what you can do you can just call the process and rest export of excel u can do using RPA process.

Like bulk data export from data service to excel. or single.

Thanks,
Arvind

[Kathirvel_Saminatha]

Okay…Thanks

[argin.lerit]

@Kathirvel_Saminatha I have a similar use-case and looking for answer too.

@Arvind_Kumar1 - This example shows that DataTable can be passed as argument to Process: https://docs.uipath.com/apps/automation-cloud/latest/user-guide/work-with-data-source-and-value-bind What are we missing here? Much thanks

[Arvind_Kumar1 (Arvind Kumar)]

@argin.lerit ,

you can pass data table from process to apps. but not from apps to process.

Thanks,
Arvind

[argin.lerit]

@Arvind_Kumar1

This passes Apps to Process

And it is configured as an In argument in the Process

Am I interpreting it wrong? Thanks for the response

[Arvind_Kumar1 (Arvind Kumar)]

@argin.lerit ,

Are you able to select the row and send it as object to input argument data table?

Thanks,
Arvind

[argin.lerit]

@Arvind_Kumar1 Yes but it’s not being received by the Process, the documentation says it’s possible with these options. Trying to figure out how to make it work

Thanks

[Arvind_Kumar1 (Arvind Kumar)]

@argin.lerit ,

Yes, I also agree that passing an object or a set of values as an array to the Input data table argument doesn’t work. We have discovered this limitation.

In the example provided, they update the “IsSelected” flag and then filter the records based on the “IsSelected” value for further processing.

I would suggest following a similar approach. Update the “IsSelected” flag in the data service, and then call the process. Within the process, establish a data service connection to filter the records based on the “IsSelected” flag. You can then perform the next operation based on the filtered values according to your business logic. Once the “IsSelected” operation is completed, you can reset the value in the process or apply another filter logic to obtain unique results.

Thanks,
Arvind