How to append data table in append range activity?

Help Activities
, ,
1

Dear all,

I have scrape a data table from a website and store as dt1.

How do i append the data table in excel using the append range activity or there is another
method to do this?

image

2

@zaffan.isa

You have 3 options

  1. Use classic activities to see them go t activities-> filter icon → select classiv → you will see a different append range

  2. Use workbook append range
    image

  3. Use a merge datatable activity and then use write rnage at the end to write once and for all

3

Hi @zaffan.isa

Use Merge Data Table activity

image

4

Hi @zaffan.isa

  1. Use Append Range activity and configure it with the following properties:
    Workbook: The Excel workbook that you want to append the data to.
    Sheet Name: The sheet name in the Excel workbook that you want to append the data to.
    DataTable: The data table that you want to append.
    Append After Range: The range in the Excel workbook after which you want to append the data.

Hope it helps!!

5

Hi @zaffan.isa

You want to append the data in the datatable, use the Append Range workbook activity to append the data to the datatable.
image

Hope it helps!!