Get Data From Queue and Create a Excel report from it

[ravig1206 (Ravi Gupta)]

Hi All,

I am working on a project where I have to create a report as well.
so for reporting I have created a Queue where I am posting all information which I require in report.
For Example

I want to get all this details in a Excel and also need to change the status of the transaction from New to Successful.

once I get all data my reporting excel will look like below.

please help

[Anil_G (Anil Gorthi)]

@ravig1206

Follow steps

While loop can be used to get eqch item

1. Get transaction item on the queue
   2 If queue item not retreived then end process else move to next step
2. Now next can use add datarow and use array of items as this {outputOfstep1.SepecificContent("Promo Id").ToString,….} add all items you need
3. Set transaction status
4. after loop use write range to write to excel

If using re framework then use add data row in process.xaml and write range in end process state

Hope this helps

Cheers