How to make a Pivot Table via UIPATH

excel
activities

#1

HI Guys,

I made a normal table on Excel, now I need to create a Pivot Table by using UIPATH. I got the short key like: Alt + V + N then Enter; however, I have not idea about how to modify the Pivot Table setting (ie. check on the column boxes) in order to build up the new table.

In this case, I’d like to move the “Credit/Debt” column into [Columns], “Country” column into [ROWS], and “Sum of Amount” into [VALUES].

Lastly, I also need to copy/paste the built Pivot Table to a new sheet.

Many thanks !

Pivot_Table.xlsx (13.2 KB)


#2

Do we have a solution for this?


#3

Hi , may I know what you are looking for…


#4

hi Guys

Check this link for your reference regarding Pivot
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Pivot-Table-Create-Pivot-Table-in-Excel-with-C-/VB.NET.html

We can create based on assign statements and manipulate the operations

Thanks
Ashwin S


#5

I have build lots of Excel & PDF Activities which we use on a daily routine.
Activities are as follows : -

  1. Pivot Table - Works with or without Excel Application Scope.
  2. Filter Range / Data - Works with or without Excel Application Scope.
  3. Find & Replace - Advanced Technology. (See the video)
  4. Text to Columns - Fixed width & Delimiter.
  5. Copy paste data - To same workbook or to other workbook without any format loss.
  6. Remove Duplicates - Single / multiple columns.
  7. Update Status in an Excel sheet after processing some invoices or any (Completed, Success, Closed, etc)
  8. Clear contents - To delete / clear the data of a given column.(See the function lists in drop-down)
  9. Excel Save as - To save the excel in different format (.xls to .xlsb OR .xlsm to .xls)
  10. Cells Formatting - To set the columns in a required format (General, Text, Number or any custom format)
  11. Export PDF to Excel.
  12. Export Notepad to Excel.
  13. Extract specific lines from Notepad and paste into an Excel.
  14. Extract specific lines from PDF and paste into an Excel.

All activites under custom activities in : - https://uipath.devpost.com/submissions
Kindly go through each of the activities…


#6

Good effort man (Y)
But every time I run “Create Pivot” activity this error appears!


appreciate your response.

Thanks.