Export Data to Excel

Help Apps
,
1

Hi All,

Good Day to everyone.

I have use case on UiPath apps, where i have built UiPath apps that uses one of the data services for data handling. I have added button in apps to export data to an excel file calling a process from backend(Process from backend queries the record and using build data table i am appending row and writing to excel).As the count of data is getting more in apps, the process is taking longer time to get data into excel. there is much latency for less number of rows, in terms of scalability with more rows of data it will take huge time to generate files. Is there any otherways to make it efficient and optimised so that it can facilitate data export in very fews seconds. I am checking is there any ways like using scripts or code or using any integration services we can achive the required one.

Any leads or friends can have any ideas or approaches feel free to add your approaches.

Thanks
Shiva

2

Hi @shivappa.katti1 ,
have you tried using write range directly in this app
calling another process seems to take more time
regards,

3

Hi @Nguyen_Van_Luong1

As i know, write range is studio activity. there is no such activities to do write in apps. since its studio activity write range can only be used from the process called.

Regards,
Shivappa

4

oh sorry I mistook it for online studio
hope you have other way

5

Hi @shivappa.katti1 , it is not recommended to use UiPath Data Service as a large scale database, where your query needs to return a large dataset. May be you can spin up a local SQL Server Express or even a SQLite DB?

6

Can you please help me to understand more on how can i use SQL connection to UiPath apps for doing crud operations in DB .

Thanks
Shivappa