How can i append the rows of a datatable to an Excel file

Help Activities
, , , ,
1

Hello, i am working with Reframework and in Process.xaml i have a datatable argument with 12 columns. For each transaction, this datatable holds between 1 and 5 rows of data. Now i passed it to another workflow. In this workflow i need to append this data to an excel file with the same columns as the datatable. So in the end of the process im left with an excel file with the data from all the transactions.
How can i achieve this with activities? i am relatively new to UiPath so i don’t know how to work with invoke code.
Thank you in advance.

2

@andre.carneiro

There is an append range activity which can be used…which would append the datatable you provided at the end of the excel file

Cheers

3

Thank you for the reply. I tried but i get this error:
image

4

Hi @andre.carneiro ,

Check whether system.xml is imported in your project,

image

if its not you can import it by going to the imports tab at the bottom of the studio.

image

5

@andre.carneiro

Can you show how you configured the activity

Also as menyiones above check the references in imports at the bottom

Cheers

6

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