I need a help in a excel automation

Help Studio
, ,
1

I have an excel which have two sheets, I have a transpose data in sheet 2 with column Name - Ab and it starts from 1 end ends on 18 now i have to take each row i.e from AB onwards and fill it in other sheet in column D. please help

2

@akv

It’s better if you can provide sample Input files and sample output file you are expecting

Thanks

3

testabc.xlsx (9.6 KB)
here is a example and sheet from row Ab the end row is not defined there will be n no. of data and in sheet2 it is highlighted by yellow color where i have to fill the data i.e D4:D23

4

@akv

Use Read Range activity as AB to your end range

Later you can use Write Range and give the Range from D

Hope this may help you

Thanks

5

i used it but what it did it write complete data from d to last row, i have to take data one by one and fill it in D4:D24

6

Hi.

  1. Use the read range activity to get the data from the first sheet. Specify the sheet name (“Sheet 1”) and range “AB1:AB18” in the activity’s properties.
  2. Use the write range activity.
    In range property, insert “D4:D24” and in Sheet Name “Sheet 2”.
7

@akv

Okay, you can use For each activity and use write cell activity for reference check below post

Hope this may help you

Thanks

8

thanks buddy i resolved now i have one more doubt.
I have to filter the data in excel
In sheet 2 and in D4 column there is customer id now i have to take it and filter the data in other sheet by preserving the details
in other sheet data is like
cust id num po date
how to do that plz guide me

9

@akv

Use For Each loop for Example DT1 which is Sheet2 after that you can use Assign activity as CustomerID= row(“Customer ID”).ToString

Now use Filter Datatable activity and use which is other sheet let’s say DT2 in that where the “CustomerID” = CustomerID

output as some temporary DT let’s say DT3

Use If Condition If the DT3.Rows.Count > 0 that means it has a matching row / rows

Else No match

Hope this may help you

Thanks

10

can you please send me the workflow i am giving you the excel
testabc.xlsx (9.1 KB)

11

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