I have build lots of Excel & PDF Activities which we use on a daily routine.
Activities are as follows : -
- Pivot Table - Works with or without Excel Application Scope.
- Filter Range / Data - Works with or without Excel Application Scope.
- Find & Replace - Advanced Technology. (See the video)
- Text to Columns - Fixed width & Delimiter.
- Copy paste data - To same workbook or to other workbook without any format loss.
- Remove Duplicates - Single / multiple columns.
- Update Status in an Excel sheet after processing some invoices or any (Completed, Success, Closed, etc)
- Clear contents - To delete / clear the data of a given column.(See the function lists in drop-down)
- Excel Save as - To save the excel in different format (.xls to .xlsb OR .xlsm to .xls)
- Cells Formatting - To set the columns in a required format (General, Text, Number or any custom format)
- Export PDF to Excel.
- Export Notepad to Excel.
- Extract specific lines from Notepad and paste into an Excel.
- 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…