Create Pivot tables in excel

activities
studio

#1

In my requirement, I need to create pivot tables from the existing table, can anyone suggest how to proceed with that?


#2

(a) Use the recording facility to create the workflow
(b) make the necessary changes to suite your requirements like no of rows etc…


#3

Sorry @skini76, can you once explain me the two points mentioned.


#4

(a) Hope you know the recording facility available in UiStudio, manually create a pivot & record the steps using recorder which will create the workflow to create Pivot.
(b) You may have to make some changes in this workflow, because your dataset may keep changing (ie no of rows).

If still not clear, refer the online tutorial on how to use the recording facility


#5

you can create a macro, run it


#6
  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…