Read / Write / Edit Excel Data


I have an excel table with different columns and would like to insert a new column + name the column header. In the new column I need only the last six digits from another column e.g. column “J”. After that I have to create a pivot table and write it back to excel and save the file on my desktop.

I started with “Excel Application Scope” and “Read Range” to read in the file.


As mentioned I don’t know how and with which activities I can continue . Could you please support me with this UiPath process?
Thank you very much in advance!

Best regards,


Use Add data column activity to add the column and name the column

For Pivot table, you can use below


Hope this will help you


1 Like

Hi @Joki

The below video will give you an idea about creation of pivot table.

Thank you.


Read Range the sheet into a datatable. Manipulate the data in the datatable (ie add columns etc). Write Range to a new Excel file. Delete old file if desired.

Hi @Joki

We can create pivot table using invoke vba activity


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