How to make the above work with uipath?

Help Studio
, ,
1

I have question

I have a CSV file, then I want to take three specific columns in the CSV and copy the data into the Excel file. In an Excel file you can also set the row columns.

After the data is in the Excel file, I want to create a pie chart that is placed next to the data.

how to make the above work with UiPath?

2

Hi @Kia1

=> Read CSV
Output-> dt

=> Use below syntax in Assign:

Dt_Output = dt.DefaultView.ToTable(False, "Column1", "Column2", "Column3")

Replace Column1, Column2, Column3 with your column names
=> Write Range Workbook Dt_Output

Regards

3

Thankyou,

After the data is entered into Excel, do you know how to make a pie chart from the data in Excel?

4

Hi @Kia1

For that you can use Excel activities. If possible share the excel file and requirements I will help you with flow.

Regards