製品

Studio

Studio Web

StudioX

Automation Ops

Document Understanding

検索

サインイン

製品

Document Understanding

検索

Opteamix LLC - Timesheet Automation

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す →

Opteamix LLC - Timesheet Automation

作成者: Opteamix LLC

テンプレート

<100

要約

Reusable template for extracting employee ID, name, approver name, date, and total hours from weekly timesheet (PDF files) and consolidating monthly report.

概要

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).

機能

This template allows developers to quickly modify and understand new logic to consolidate timesheets from weekly PDF files.

その他の情報

依存関係

UiPath Studio, Ms Excel, Acrobat Reader

コード言語

Visual Basic

公開者

Opteamix LLC

公開者ページを表示