EXCEL TO EXCEL AUTOMATION

Help
1

Hi. I’m newbee for uipath automation.

Can someone help me how to automate excel file to another excel file.

image
image1360×767 171 KB

First picture the one that was boxed. That row will be validated.

Need some assistance on this. Is it possible from excel file to another excel format
will be automated ?

Thank you.

2

@Rogel_Barbadillo,

not enough information mate…

please tell me Validation means what exactly is happening??/

3

required your requirement indetails.

4

Hi.

See picture.
This is the first excel file.

image
image1366×768 171 KB

I will send the second pic in the next thread.

Thank you.

5

Hi.

Please see second picture.

image

This will be the output once the automation is running.
The yellow highlighted are the data that are coming from the first excel file.
Need your help on this matter.

Thank you.

6

@Rogel_Barbadillo,

Could you please tell us the steps those you manually do?
We are unable to understand your requirement by looking at your description.

Cheers,
Pankaj

7

Hi.

Each row. We will get the Supplier, BILLING MONTH,
WHOLE MONTH DEPLOYMENT RATE,
OVERTIME PAY,
LEGAL HOLIDAY DUTY,
SPECIAL HOLIDAY DUTY,

After that we will manually put it in the other excel file (second picture).

Thank you.

8

@Rogel_Barbadillo,

As per my understanding, we have to read one by one row from ENROLLED SUPPLIERS- MAY sheet and enter into SUMMARY sheet and then calculate Billed Amount. Is it Right ?

1 Like
9

Hi Sir.

Yes that’s exactly i want to sir.
And then Save it to Excel file form.

Thank you.

10

You can do it using macro, just try to to record the macro, then made small changes on the range selected and other and invoke that VBA code from UiPath.

11

Hi.

Is macro has a free trial ?
Because today i’ve been using UIPath.

Thank you.

12

[quote=“Rogel_Barbadillo, post:9, topic:99939, full:true”]
Hi Sir.

Yes that’s exactly i want to sir.
And then Save it to Excel file form.

Thank you.

13

@Rogel_Barbadillo,

Follow below steps:

  1. Use read range activity inside Excel Application Scope and will give you output as DataTable say DT

  2. Iterate using ForEach row in DT
    Assign index = DataTableName.rows.indexof(row)+2

    Supplier = row(“Supplier”).toString
    Billing Month = row(“Billing Month”).toString
    Whole month deployment rate = row(“Whole month deployment rate”).toString
    overtime pay = row(“overtime pay”).toString
    legal holiday duty = row(“legal holiday duty”).toString
    special holiday duty = row(“special holiday duty”).toString

    Then take write cell activity and write into respective fields under SUMMARY sheet and then take Read Cell and read Billed Amount and assign it to string variable for suppose ‘getBilledAmount’.

And Finally take one more Write cell activity to write Billed Amount into Billed Amount Column under ENROLLED SUPPLIERS- MAY sheet.

Eg. for suppose Billed Amount column is ‘S’ then use below one:

   In Write Cell, Range: "S"+index.toString      and  value:  getBilledAmount

End loop.

Regards,
Lakshman Ganta.

1 Like
14

Hi Sir,

Thank you for your quick response.
Can you please send sample .xaml for this uipath activities so that i can understand more in hands-on.

Thank you.

15

Hi Sir,

Thank you for your quick response.
Can you please send sample .xaml for this uipath activities so that i can understand more in hands-on.

Thank you.