Created
April 29, 2022 09:46
-
-
Save kujirahand/0ee48838128896deb8cc4f2b6f9f65d4 to your computer and use it in GitHub Desktop.
年齢早見表を自動作成/Power Automate Desktop
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
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime | |
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''yyyy''' Result=> yyyy | |
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance | |
LOOP LoopIndex FROM 1 TO 50 STEP 1 | |
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''%yyyy - LoopIndex + 1%年''' Column: 1 Row: LoopIndex | |
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''満 %LoopIndex - 1% 歳''' Column: 2 Row: LoopIndex | |
END | |
Folder.GetSpecialFolder SpecialFolder: Folder.SpecialFolder.DesktopDirectory SpecialFolderPath=> SpecialFolderPath | |
Excel.CloseExcel.CloseAndSaveAs Instance: ExcelInstance DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: $'''%SpecialFolderPath%\\年齢早見表.xlsx''' | |
# [ControlRepository][PowerAutomateDesktop] | |
{ | |
"ControlRepositorySymbols": [], | |
"ImageRepositorySymbol": { | |
"Name": "imgrepo", | |
"ImportMetadata": {}, | |
"Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}" | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment