Skip to content

Instantly share code, notes, and snippets.

@kujirahand
Created April 29, 2022 09:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kujirahand/0ee48838128896deb8cc4f2b6f9f65d4 to your computer and use it in GitHub Desktop.
Save kujirahand/0ee48838128896deb8cc4f2b6f9f65d4 to your computer and use it in GitHub Desktop.
年齢早見表を自動作成/Power Automate Desktop
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