How to write Queue data into Excel?

[Anonymouss (Akhil Pandey)]

Hii,

I have made 6 different queues into the orchestrator and stored data accordingly,

I have done this via UiPath Studio.

Likewise, I have made 6 queues. now I want to retrieve all queue data into a separate Excel file.

What can I do?

[sanjay3 (Sanjay)]

Hi @Anonymouss

You can use Get Queue Items activity for this

Activities - Get Queue Items (uipath.com)

[AJ_Ask]

Hi @Anonymouss

HO To get the all the transaction item from the queue

Hi @copy_writes This is how the basic structure will look as there is limitation for get queue items to fetch only 100 we need to add skip with increase in 100 each time [image] also you need to add if condtion to break the loop if the count is 0 in the queue. Add Skip counter with 100 for next set of queue items. In this you can use the for each queue item to create a datatable with all the data. [image] Hope this helps

Hope this helps

[Anonymouss (Akhil Pandey)]

Hello, @AJ_Ask

I am glad to get answers from your side but I want get data from the queue which is located in Orchestrator-> Folder Test_REF → Queue →

now I want to get all queue Transactions into excel file

I have used “Get Transaction” Activity in UiPath Studio, and passed the Orchestrator Folder name and Queue name

but I didn’t know how can I get those data into variables. Like varQueueItem = QueueName.SpecificContent(“Data1”) etc… can I get data like wise?

and then after I want to pass this variable(varQueueItem) into write cell activity

Might be my question/Problem is understandable.

Thank you.
Akhil

[Anonymouss (Akhil Pandey)]

Hello Mr. @sanjay3

I have used this Activity

from this activity, I get queues data (in this queue I have stored “Name”, “Surname”, “Test Score 1”, and “Test Score 2” )

and I need only “Test Score 1” and “Test Score 2” data, How can I store in variable

Thank you,
Akhil

[AJ_Ask]

Hi @Anonymouss

Yes you can use

TestScore = Transcation_item.SpecificContent("Test Score 1").ToString

[Anonymouss (Akhil Pandey)]

Thank you @AJ_Ask

I understand this but I have a 6 queue and I want to store each queue’s data in a different Department sheet

I want to make each queue for an Excel file according to the department name.

---

According to my knowledge I have to write multiple assign activities and lots of Write cell activity for each queue, But need Optimized solution I don’t want to write multiple time write cell activity and also don’t want to multiple assign activity for each 6 queue.

One again Thank you @AJ_Ask,
Akhil

[AJ_Ask]

Then you have to use get queue items only or orchestrator API.

1. In get queue items you create datatable of all the relevant data

2.Using write datatable to excel activity you can write it to excel without using the multiple write activities.

[Gautham_Pattabiraman]

Hey @Anonymouss ,

Here is how you can convert the Get queue items activity output to datatable

Use a Build DataTable activity to create the structure of the DataTable with the desired columns.

Iterate through each QueueItem in the IEnumerable using a For Each activity.

Inside the For Each activity, use Add Data Row activity to add each QueueItem’s properties to the DataTable as a new row.

Once data table is created you can easily write the data into a excel workbook.

Hope this helps you out.

Thanks,
Gauutham.

[sanjay3 (Sanjay)]

Hi @Anonymouss

Suppose output of get transaction activity is TransactionItem

TransactionItem.SpecificContent(“Test Score 1”).ToString

For Getting All the Transaction to Spreadsheet

Create a Data Table using Build Data Table Activity with Column Name Test Score1 and Test Score2 (output=dt_TestScore)

Use Get Queue Item Activity for getting the queue items, from the property panel you can select the which type of transaction item you want to put in the spreadsheet, and output of this activity is QueueItems

Use For each for iterating where type argumment is UiPath.Core.QueueItem

In the For Each use Add data row Activity, for eg
{currentItem.SpecificContent(“Test Score1”).ToString,currentItem.SpecificContent(“Test Score2”).ToString}
DataTable=dt_TestScore

After the For each use Write Range Workbook and make sure that you had check on Add headers at the property panel and in the DataTable section put the dt_TestScore

[Anonymouss (Akhil Pandey)]

Hii @AJ_Ask,

I got the solutions and Thank you for helping me in this matter.

Thank you,
Akhil

[Anonymouss (Akhil Pandey)]

Hii @Gautham_Pattabiraman,

It’s working and helpful information for all who face this problem.

Thank you,
Akhil

[Anonymouss (Akhil Pandey)]

Hii @sanjay3 ,

Thank you for sharing this informative knowledge, I got my answers as I required.

Thank you,
Akhil

[Gautham_Pattabiraman]

Happy to have helped you @Anonymouss