How to Use Excel Append Range Activity?

[sumouse (ChoboIT)]

I want to add and save DataTable data to the data already saved in the Excel ‘val_list’ sheet.

1. ‘Test.xlsx’ sheet name : Val_List
   

2. DataTable
   {D, 30}

How should I write each argument?

[lrtetala (Lakshman Reddy)]

Hi @sumouse

Try this

Final Excel:

Output:(Final Excel)

Cheers!!

[sumouse (ChoboIT)]

Your ‘append activity’ and mine are of different types. Please see the image

[lrtetala (Lakshman Reddy)]

@sumouse

This is another way and simple

How to Use Excel Append Range Activity?

Hi @sumouse Try this [image] [image] Final Excel: [image] Output:(Final Excel) [image] Cheers!!

[gRao]

Hi @sumouse ,

If you are using a template or file with data and header already present then:
Try this

Else

[Krishna_Raj]

@sumouse

Excel Append Range activity

@haiyan.he Yes,the path of the excel,sheetname should be same and datatable need to append in the excel. [image] check the thread for more info

check the thread