English
Summary
Reusable template for extracting employee ID, name, approver name, date, and total hours from weekly timesheet (PDF files) and consolidating monthly report.
Overview
- Extract employee ID and name from PDF files and store it in a variable.
- Use the start process to open PDF files and extract table format data using Extract structure data activity.
- Remove unwanted empty rows and keep only required data (in this example having project code and a total number of hours for the entire week).
- Update the date into the respective weekly data table from the weekly folder structure.
- Merge all the data tables and get unique employee ID and again join all the weekly data table (1,2,3,4,5) with unique ID table using join data table activity.
- Now, all the data will be updated into the master data table and calculate all the weekly hours (if there is no weekly hours place ‘-’ in the blank cell).
- Merge the duplicate item into one cell and format the report structure using simple VBA code (if required – optional).
Benefits
Published: 11 Jan 2021 | Updated: 11 Jan 2021
Trusted Source
License
MIT
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Compatibility
Studio: 21.4+
Dependencies
UiPath Studio, Ms Excel, Acrobat Reader
Documentation
Support
UiPath Community SupportSimilar Listings
Ephesoft QuickScreen ID Reader
QuickScreen is a global ID (Passport/Driver's License/National ID) image reader that is pre-trained for ID data extraction, photo crop and signature crop.
2
Data Extraction Model for Etisalat Ebills
Extracting Utilization data from Etisalat Monthly bills using Regex and UiPath PDF Activities.
3
Bronze Certified
Supported by Publisher
Long Running Workflow Template for Task Creation
Provides a template workflow that can be used to get transaction data from a queue and create tasks for the user to approve, and continue the task after resuming depending on user decision
2 reviews
207
Silver Certified
Supported by Publisher
Business Loan Processing Automation
Business Loan requires analysis of the Balance Sheet to extract information like Balance Sheet, Cash Flow Statement, P&L and notes to account to give credit rating. All can be automated using UiPath
1 reviews
23
Bronze Certified
