PREVIEW

範囲をオートフィル

スコープ

• https://www.googleapis.com/auth/drive

• https://www.googleapis.com/auth/spreadsheets

入力

• Add new connection - You must connect to Google Sheets to use this activity.
• Spreadsheet - The spreadsheet where the autocomplete will be performed. This property supports String variables and string formatted values.
• Spreadsheet sample - Select a file with the same range and column structure as the variable file. This field becomes visible when you select the Use spreadsheet template option.
• Sheet name - The name of the sheet where the autocomplete will be performed. This property supports String variables and string formatted values.
• Rule range - The range you specify for the autocomplete process. This property supports String variables and string formatted values (enter your range in A1-style notation). The default value is A1:B2.
• Fill length - The number of rows or columns you want to fill. This property supports Int32 variables and Int32 formatted values.
• Direction - Specifies the direction on which the autocomplete will take place. Select from fouroptions: Up, Down, Left, or Right.