How to insert column to excel after data scraping?

#1

Hi, I have an excel which I have to use 2 columns to form the result excel. At first; I am doing below activities;
1-Use read range activity to read excel.
2-For each activity to make data scraping for each data in B column.
3-Append Range activity to form the excel.

The excel is formed but I also want to insert a column to excel and write the customer ID which was in A column of my first excel. Colud you please help?

#2

Hi @aysyavuz
Before append range use build datatable and try to append the datatable u LL get it

Thanks
Ashwin.S

#3

Hi @aysyavuz

Welcome to UiPath community buddy

For this we can use INVOKE METHOD activity like this, where target object is yourdatatablename.Columns

image
image.png1284×568 60.2 KB

Hope this would help you
Cheers @aysyavuz

1 Like
#4

Hi @aysyavuz

I have created workflow based on your workflow before run this workflow please open this
URL (https://acme-test.uipath.com/work-items). I used ACME site for data scraping this
workflow will help you.

InsertColumnAfterDataScrape.zip (137.8 KB)

#5

Hi @kommijeevan, @Palaniyappan

I tried to use invoke method but the activity did not accept SetOrdinal or Add methods. Am I doing something wrong?

InvokeMethod|690x388 .

Thanks
Aysegul

#6

Fine kindly share the xaml if possible
Cheers @aysyavuz

#7

Thanks a lot, unfortunately confidential. We tried another method with Add Column, Assign and If activities and it seems working.
Cheers @Palaniyappan

1 Like
#8

Great
Cheers @aysyavuz