Having trouble in working with Excel

Invoices.xlsx (11.4 KB)
result demo.xlsx (8.7 KB)
Hello Everyone! Can Someone please help me carry out my task. I tried a lot can’t get my desired output. Files are attached. Invoices.xlsx is the main file to work on and result demo.xlsx is my desired output. I group up the ClientNames, what is the workflow after that. Explained and detailed answers will the appreciated as I am new to RPA Journey. Thanks

Hi @Zen_Ahmed ,

Can you elaborate your query.

Thanks,
Ashwin

I actually want output as my result demo.xlsx from my Invoices.xlsx. I have no idea how to carry out the workflow.

Hi @Zen_Ahmed ,

I have seen the excel files which you have provided, can I know on what basis your entering the values like from where are you retrieving InvoiceAmount & InvoiceCount

Thanks,
Ashwin

Total_InvoiceAmount is the sum of all invoice of specific client like Units&Product Inc.
Total_InvoiceCount is the total number of invoices issued to a specific Client.

Hi @Zen_Ahmed,

Based on the information, try the below idea

  1. Use Build Datatable, to create the required column
  2. Use For each row, create a datarow and assign the values.
  3. Create Add Datarow & add this datarow value.
  4. Use Write Range to write into the excel.

Thanks,
Ashwin

HI @Zen_Ahmed

Here is the workflow

You can refer to the steps in the workflow
Invoices.zip (70.8 KB)

Hope it will solve your query

Regards
Sudharsan

1 Like
  • I appreciate your consideration, help and time. Thank you soo much

2
1
Can you please guide me to steps attached as pictures?

That is for returning the number of invoice id in excel file

Regards
Sudharsan

1 Like

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