共通シナリオについて

オートメーションをより短期間で設計できるようにするために、StudioX には共通シナリオが付属しています。これは、再利用可能なオートメーションの部品であり、あらゆるプロジェクトに追加できます。共通シナリオとは、タスクまたはタスクの一部を自動化するための、論理的な順序でグループ化された 1 つまたは複数のアクティビティのことです。
Common scenarios are context-sensitive, which means the available options depend on where exactly you are in your automation. For example, in a Use Desktop Outlook App activity, the available common scenarios are related to Outlook tasks, such as Download email attachments. For a list of available common scenarios, see Common Scenarios Descriptions.

プロジェクトで共通シナリオを使用するには、次の手順を実行します。

[デザイナー] パネルのシナリオを追加する場所で [アクティビティを追加] アイコンをクリックします。
[アクティビティを追加] 検索バーが、関連性の高いアクティビティや共通シナリオが先頭に示されたリストとともに表示されます。
追加する共通シナリオをクリックします。
シナリオ内のアクティビティが [デザイナー] パネルに追加されます。
必要に応じて、追加されたアクティビティを設定します。

共通シナリオの説明

下の表に、StudioX で使用可能な共通シナリオと、必要になる可能性がある設定について示します。共通シナリオは、それらを追加先とすることのできるアクティビティに基づいて並べられています。

オートメーションの任意の場所

Common Scenario	What It Does	What You Need to Configure
Add date to folder file names	Prompts for the folder that contains the file names to update, adds a Write Cell activity that enters today's date in a cell in the Project Notebook, and a For Each File in Folder activity that iterates through the selected folder. Inside For Each File in Folder, another Write Cell activity copies the name of the current file in the iteration to the Project Notebook, and a Move File activity adds the current date to the name using a formula in the Project Notebook.	-
Delete folder and subfolders	Prompts for the folder to delete and adds a Delete Folder activity configured to delete even if the folder contains files or subfolders.	-

Excel ファイルを使用

以下の共通シナリオは、[Excel ファイルを使用] アクティビティ内で追加される場合を除き、プロジェクトノートブックとともに使用できます。

Common Scenario	What It Does	What You Need to Configure
Merge ranges	Adds an Append Range activity that copies all the values in a range and appends them to another range, and a Delete Rows activity that removes all duplicate rows from the destination after the data is appended.	- In Append Range, select the source and destination ranges. - In Delete Rows, select the destination range.
Repeat actions for rows in Excel range	Adds a For Each Excel Row activity.	- Select the range to use. - Add the activities to repeat inside For Each Excel Row.
Paste Excel chart into Powerpoint Note: This scenario is available only when Use Excel File is placed inside an Use PowerPoint Presentation activity.	Adds a Get Chart activity that selects a chart from an Excel file and copies it to clipboard, and a Paste Item into Slide activity that inserts the saved Excel chart into a PowerPoint presentation.	- In Get Chart, select the source chart and select Copy to clipboard in the Action field. - In Paste Item into Slide, select the Slide number and the Content placeholder in the presentation.

PowerPoint プレゼンテーションを使用

Common Scenario	What It Does	What You Need to Configure
Paste Excel chart into Powerpoint Note: For this scenario to work properly, place a Use Excel File activity inside the Use PowerPoint Presentation activity before adding the scenario.	Adds a Get Chart activity that selects a chart from an Excel file and copies it to clipboard, and a Paste Item into Slide activity that inserts the saved Excel chart into a PowerPoint presentation.	- In Get Chart, select the source chart and select Copy to clipboard in the Action field. - In Paste Item into Slide, select the Slide number and the Content placeholder in the presentation.

アプリケーション/ブラウザーを使用

Common Scenario	What It Does	What You Need to Configure
Fill form from Excel	Adds a For Each Excel Row activity that contains three Type Into activities configured to copy the data from the first, second, and third columns in the selected range, and pastes it into three indicated fields in the target application or web page. By default, the range `A1:C3` from the Scratchpad sheet of the Project Notebook is used.	- Make sure the range from the Scratchpad sheet of the Project Notebook contains the data to enter in the form (by default `A1:C3`). You can add another file in a parent Use Excel File activity and/or select another range for For Each Excel Row. - Indicate the target element for each Type Into activity. - Add or remove Type Into activities depending on the number of fields on the form.

デスクトップ版 Outlook アプリを使用

Common Scenario	What It Does	What You Need to Configure
Repeat actions for emails	Adds a For Each Email activity.	- Select the folder or messages to use. - Add the activities to repeat inside For Each Email.
Send email	Adds a Send Email activity.	Configure the Send Email activity.
Download email attachments	Prompts for a folder where to save the attachments, adds a Save Email Attachments activity, then a For Each File in Folder containing a Write Line activity configured to display the file names in the Output panel.	-
Email folder backup	Prompts for a folder on the computer where to save emails, adds a For Each Email with a Save Email activity inside it.	Select the folder to back up from For Each Email. The Inbox is selected by default.
Create contacts details database	Adds a For Each Email activity configured to use the emails from the Inbox, Write Cell and Append Range activities inside For Each Email to copy the senders from each email to a new Contacts sheet in the Project Notebook, and a Delete Rows activity to remove duplicates.	-
Copy email details to Excel	Adds a series of Write Cell activities that add the email fields as column headers in a new sheet named Emails in the Project Notebook. Then adds a For Each Email activity that contains a series of Write Cell activities that copy the fields of each email to the Scratchpad sheet, and an Append Range activity to copy all the fields to the Emails sheet.	In For Each Email, select the folder from which to get the emails. The Inbox is selected by default.
Email all files in a folder	Prompts for a folder to select and adds a Send Email activity configured to use the files in the selected folder as attachments. The current Outlook account is added by default to the To field.	Edit the default values added to the fields of the activity to customize the email, for example add one or more recipients, or edit the Subject and Body.

繰り返し (各メール)

Common Scenario	What It Does	What You Need to Configure
Reply to email	Adds a Reply to Email activity to reply to the current mail in the iteration, a Mark Email as Read/Unread activity, and a Move Email activity to move the email to another folder.	- In Reply to Email, edit the email body. - In Move Email, select a folder where to move the email.
Forward email	Adds a Forward Email activity to forward the current mail in the iteration, a Mark Email as Read/Unread activity, and a Move Email activity to move the email to another folder.	- Configure the Forward Email activity. - In Move Email, select a folder where to move the email.
Move email	Adds a Move Email activity to move the current email in the iteration to another folder.	In Move Email, select a folder where to move the email.
Save and process email attachments	Prompts for a folder where to save the attachments, adds a Save Email Attachments activity and a For Each File in Folder activity where to add activities to repeat for each attachment.	Add activities to repeat for each attachment inside For Each File in Folder.

繰り返し (フォルダー内の各ファイル)

Common Scenario	What It Does	What You Need to Configure
Try open file as Excel	Adds an If activity that checks if the current file in the iteration has the `.xlsx` extension. The Then branch contains a Use Excel File activity that adds the current file to the project if the condition is met.	-
Add date to file and move to subfolder	Adds a Create Folder activity that creates a subfolder named `Processed` in the current folder, a Write Cell activity to copy the name of the current file in the iteration to the Project Notebook, and a Move File activity that moves the current file to the subfolder and adds the current date to the name using a formula in the Project Notebook.	-
Group files by type	Adds a Write Cell activity to copy the name of the current file in the iteration to the Project Notebook, a Create Folder activity that creates a subfolder in the current folder named with the extension of the current file using a formula in the Project Notebook, and a Move File activity that moves the current file to the subfolder.	-
Group files by size	Adds an If activity that checks if the current file in the iteration is smaller than 100KB. The Then branch contains a Create Folder activity that creates a new folder with the title set to 100 K and a Move File activity that moves the current file in the iteration to the newly created folder. The Else branch contains an If activity that checks if the current file is smaller than 1000KB. Both the Then and Else branches contain a Create Folder and Move File activity.
Group files by creation date	Adds a Write Cell activity to copy the creation date of the current file in the iteration to the Project Notebook, a Create Folder activity that creates a subfolder in the current folder named with the creation date of the current file using a formula in the Project Notebook, and a Move File activity that moves the current file to the subfolder.	-
Copy file info to Excel	Adds a series of Write Cell activities that copy the name, full path, size, and creation date of the current file in the iteration to the Scratchpad sheet and an Append Range activity to copy all the fields to the Files sheet.	-

UiPath StudioX

UiPath StudioX ガイド

共通シナリオ