Write a lot of data from variable to excel

Help Studio
, , ,
1

Hello, I have the following case, I extracted information from a portal which I stored in different variables to be precise, 20 different variables.

now i want to write the value of each of those variables in an excel record but i don’t want to write it cell by cell.

Any way to write all the data from the 20 variables in a single excel row with as few activities as possible?

The excel file has 20 columns, one for each data of each variable.

image
image738×565 96.6 KB

2

Hi @alexis.mendoza

To do this, you will need to create an array or list that contains the data from your variables, and then use the Write Range activity to write the data to a specific range of cells in the Excel file.

Regards,
Kaviyarasu N

3

HI @alexis.mendoza

You can try with Add Data row activity
https://docs.uipath.com/activities/docs/add-data-row

Regards
Sudharsan

4

After adding all the data to datatable you can use write range to write the data in the Excel sheet

Regards
Sudharsan

5

No Shows how to gather all the data from my variables in a data table

6

Hi @alexis.mendoza,
First of all you need to build Data table then you will use add data row in that Data table and you can find below video for how to build data table then you can continue above video.

7

Based on the columns header you need to add the String data in the string of array in the Array Row field
image

Regards
Sudharsan