Skip to content
Kokoroe
Search
Ctrl
K
Cancel
X
GitHub
Select theme
Dark
Light
Auto
Select language
日本語
English
हिन्दी
Menu
Office Scripts
What are Office Scripts?
Differences from VBA
Basic syntax
Conditional statements
Loops (iteration)
Controll excel books
Adding a worksheet
Getting a worksheet
Controll Excel sheets
Activating a worksheet
Copying a worksheet
Getting the last row
最終列の取得
Control ranges
値の取得と書き込み
値の一括取得と書き込み
行番号・列番号で指定
Controll string
文字列の検索
Replacing strings
文字列の分割
Extracting part of a string
Converting to and from numbers
空白の削除
入力値の形式チェック
Working with arrays
Implementing asynchronous processing
Working with dates
月末日・月初日の取得
n か月後の日付
Regular expressions
Pausing execution
Google Apps Script
What is Google Apps Script?
Controll spreadsheet
Getting the locale
Getting the theme
Getting the time zone
Controll Google Calendar
Getting a calendar
Adding a calendar
Deleting a calendar
Adding an event
Getting owner information
Managing protected ranges and sheets
Getting range values
Getting the number of sheets
Power Automate Desktop
What is Power Automate Desktop?
Text
Trimming spaces
Padding with zeros or spaces
Changing letter case
Generating random strings
Fixing garbled characters
Number
Showing thousands separators
Getting the decimal part
Generating random numbers
Truncating decimals
Rounding
Date
Getting the current time
Formatting
Subtracting from a date
Getting the day of the week
List
Removing items
Creating a list
Multidimensional arrays
Removing duplicates
Merging lists
Sorting
Multiple initial values
Clipboard
Working with the clipboard
Clearing data
Getting data
Changing data
Flow
Branching on multiple conditions
Infinite loops
Mouse and keyboard
Double-clicking
Middle-clicking
Variants and data types
Defining variables
Set variable
Variables with multiple properties
Creating a list from JSON
Creating a variable from JSON
Blocking user input
Encrypt
Decrypting files and text
Encrypting files and text
Calculating hash values
Branching on error conditions
Scheduling
Extracting images from a PDF
Printing a file as a PDF
Reading a file as text
Saving a screenshot
Fixing slow execution
Waiting less than one second
XML
Getting an element's value
Adding an element
Writing to a file
Blog
X
GitHub
Select theme
Dark
Light
Auto
Select language
日本語
English
हिन्दी
Blog
This content is not available in your language yet.
IEサポート終了にあわせて、Power Automate Desktopで変えるべきアクション
2022-04-04
