Group1 | Group2 | Group3 | Actions | Description |
---|---|---|---|---|
Variables | Data table | Create new data table | Creates a new data table variable | |
Variables | Data table | Insert row into data table | Inserts a row at the end or before a specific index value | |
Variables | Data table | Find or replace in data table | Finds and/or replaces data table values | |
Variables | Data table | Update data table item | Update a data table row item on a defined column | |
Variables | Data table | Delete row from data table | Delete a data table row at the corresponding row index |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[void][Reflection.Assembly]::LoadFile("C:\System\Lib\PdfSharp.dll") | |
$doc = [PdfSharp.Pdf.IO.PdfReader]::Open("C:\Test\PDF\SampleField.pdf", [PdfSharp.Pdf.IO.PdfDocumentOpenMode]::Modify) | |
$form = $doc.AcroForm | |
if($form.Elements.ContainsKey("/NeedAppearances") -eq $true){ | |
$form.Elements["/NeedAppearances"] = [PdfSharp.Pdf.PdfBoolean]::True | |
}else{ | |
$form.Elements.Add("/NeedAppearances", [PdfSharp.Pdf.PdfBoolean]::True) | |
} | |
$fields = $form.Fields | |
$fields["Name"].Value = [PdfSharp.Pdf.PdfString]::new("foo bar") |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET WindowsApplicationDriverPath TO $'''\"C:\\Program Files (x86)\\Windows Application Driver\\WinAppDriver.exe\"''' | |
SET AppId TO $'''mspaint.exe''' | |
SET WindowsApplicationDriverUrl TO $'''http://127.0.0.1:4723''' | |
SET ImageFilePath TO $'''\"C:\\Test\\Image\\TEST.png\"''' | |
System.RunApplication.RunApplication ApplicationPath: $'''cmd''' CommandLineArguments: $'''/k %WindowsApplicationDriverPath%''' WorkingDirectory: $'''C:\\''' WindowStyle: System.ProcessWindowStyle.Normal ProcessId=> AppProcessId | |
Web.InvokeWebService.InvokeWebService Url: $'''%WindowsApplicationDriverUrl%/session''' Method: Web.Method.Post Accept: $'''application/json''' ContentType: $'''application/json''' RequestBody: $'''{\"desiredCapabilities\":{\"app\":\"%AppId%\",\"deviceName\":\"WindowsPC\",\"platformName\":\"Windows\"}}''' ConnectionTimeout: 30 FollowRedirection: True ClearCookies: False FailOnErrorStatus: False EncodeRequestBody: False UserAgent: $'''Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.21) Gecko/20100312 Firefox/3. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET WindowsApplicationDriverPath TO $'''\"C:\\Program Files (x86)\\Windows Application Driver\\WinAppDriver.exe\"''' | |
SET AppId TO $'''Microsoft.WindowsCalculator_8wekyb3d8bbwe!App''' | |
SET WindowsApplicationDriverUrl TO $'''http://127.0.0.1:4723''' | |
System.RunApplication.RunApplication ApplicationPath: $'''cmd''' CommandLineArguments: $'''/k %WindowsApplicationDriverPath%''' WorkingDirectory: $'''C:\\''' WindowStyle: System.ProcessWindowStyle.Normal ProcessId=> AppProcessId | |
Web.InvokeWebService.InvokeWebService Url: $'''%WindowsApplicationDriverUrl%/session''' Method: Web.Method.Post Accept: $'''application/json''' ContentType: $'''application/json''' RequestBody: $'''{\"desiredCapabilities\":{\"app\":\"%AppId%\",\"deviceName\":\"WindowsPC\",\"platformName\":\"Windows\"}}''' ConnectionTimeout: 30 FollowRedirection: True ClearCookies: False FailOnErrorStatus: False EncodeRequestBody: False UserAgent: $'''Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.21) Gecko/20100312 Firefox/3.6''' Encoding: Web.Encod |
アクショングループ1 | アクショングループ2 | アクショングループ3 | アクション | 説明 |
---|---|---|---|---|
変数 | データ テーブル | 新しいデータ テーブルを作成する | 新しいデータ テーブル変数を作成する | |
変数 | データ テーブル | 行をデータ テーブルに挿入する | 行を末尾または指定されたインデックス値の前に挿入する | |
変数 | データ テーブル | データ テーブル内で検索または置換する | データ テーブルの値を検索または置換する | |
変数 | データ テーブル | データ テーブル項目を更新する | 定義された列でデータ テーブル行の項目を更新する | |
変数 | データ テーブル | データ テーブルから行を削除する | 行インデックスで指定されたデータ テーブル行を削除する |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Power Automate for desktopのフローを実行するPowerShellスクリプト | |
# @param [string] $flowName 実行するフロー名 | |
# @param [bool] $flgExit PAD終了フラグ | |
# | |
# 動作確認:バージョン 2.40.157.24023 (インストーラー版) | |
# | |
Param( | |
[parameter(mandatory=$true)][string]$flowName, | |
[bool]$flgExit = $false |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 実行中のPower Automate for desktop(PAD)フロー名を取得するスクリプト | |
# ※複数のフローが同時に実行されている場合([PAD.Designer.exe][PAD.Robot.exe]が複数実行されている場合)については考慮していません。 | |
# | |
$procPADDesigner = Get-WmiObject -Class Win32_Process | Where-Object {$_.Name -eq "PAD.Designer.exe"} | |
if($procPADDesigner){ | |
#デザイナーから実行している場合 | |
#[PAD.Designer.exe]のコマンドライン[processname]の値をURLデコードしてフロー名取得 | |
$regexPADDesigner = [regex]::Match($procPADDesigner.CommandLine.ToLower(), "processname=.*?&") | |
if($regexPADDesigner.Success){ | |
Add-Type -AssemblyName "System.Web" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/# ☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★ | |
祝日一覧をデータテーブルに格納 | |
※Google Calendar APIのような祝日を取得するAPIを利用しても可 | |
☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★#/ | |
SET HolidayTable TO { ^['Date', 'Summary'], ['2024-01-01', '元日'], ['2024-01-08', '成人の日'], ['2024-02-11', '建国記念の日'], ['2024-02-12', '建国記念の日 振替休日'], ['2024-02-23', '天皇誕生日'], ['2024-03-20', '春分の日'], ['2024-04-29', '昭和の日'], ['2024-05-03', '憲法記念日'], ['2024-05-04', 'みどりの日'], ['2024-05-05', 'こどもの日'], ['2024-05-06', 'こどもの日 振替休日'], ['2024-07-15', '海の日'], ['2024-08-11', '山の日'], ['2024-08-12', '休日 山の日'], ['2024-09-16', '敬老の日'], ['2024-09-22', '秋分の日'], ['2024-09-23', '秋分の日 振替休日'], ['2024-10-14', 'スポーツの日'], ['2024-11-03', '文化の日'], ['2024-11-04', '文化の日 振替休日'], ['2024-11-23', '勤労感謝の日'] } | |
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime | |
# テスト用に日時設定 | |
Text.ConvertTextToDateTime.ToDateTime Text: $'''2024/5/8''' DateTime=> CurrentDateTime | |
/# ☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★ | |
指定日の2日前から14日間さかのぼって祝休日かどうかの判定を行う |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/# ☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★ | |
APIトークンなどの変数設定 | |
☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★#/ | |
SET APIToken TO $'''(APIトークン)''' | |
SET SubDomain TO $'''(サブドメイン)''' | |
Text.FromNumber Number: 6 DecimalPlaces: 0 UseThousandsSeparator: False FormattedNumber=> AppID | |
SET SaveFolderPath TO $'''C:\\Test\\kintone\\Files''' | |
/# ☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★ | |
添付ファイルフィールドのフィールドコードをリストに設定 | |
☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★☆★#/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET PdfFolderPath TO $'''C:\\Test\\受領書''' | |
/# ☆★☆★☆★☆★☆★☆★☆★☆★☆★☆ | |
リストファイル読み込み | |
☆★☆★☆★☆★☆★☆★☆★☆★☆★☆#/ | |
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''%PdfFolderPath%\\受領書発行リスト.xlsx''' Visible: True ReadOnly: True Instance=> ExcelInstance | |
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''受領書発行リスト''' | |
Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow | |
Excel.ReadFromExcel.ReadCells Instance: ExcelInstance StartColumn: $'''A''' StartRow: 1 EndColumn: FirstFreeColumn - 1 EndRow: FirstFreeRow - 1 ReadAsText: True FirstLineIsHeader: True RangeValue=> ExcelData | |
Excel.CloseExcel.Close Instance: ExcelInstance | |
/# ☆★☆★☆★☆★☆★☆★☆★☆★☆★☆ |
NewerOlder