playground:playground
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
playground:playground [2021/09/12 23:44] – craigt | playground:playground [2023/11/03 12:11] – add List sheets description craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | {{ transformations: |
- | Category: | + | ====== |
+ | Category: | ||
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | This function returns the first value in the argument list that is //not// an [[syntax: | + | Import data from a Google Sheets file.\\ |
\\ | \\ | ||
- | =====Alternate formats===== | + | ===== Action settings |
- | This function can take from 2 to 6 values as arguments. | + | |
- | coalesce(value1, | + | |
- | \\ | + | ^ Setting |
- | =====Arguments===== | + | |Connector< |
- | ^Argument^Type^Description^ | + | |Spreadsheet< |
- | |valueN|Any|A value tested | + | |Import action|Options: |
- | **Return value type:** Any (The type of the returned, non-empty value.) | + | \\ |
+ | ==== Import table settings ==== | ||
+ | ^ Setting | ||
+ | |Sheet or range< | ||
+ | |Skip first lines< | ||
+ | |Columns don't have headers|Check this if your dataset does not include a row with header information| | ||
+ | |Load all columns|This option imports all columns in the sheet.| | ||
+ | |Load only selected columns|This option allows you to select which columns to import. | ||
+ | <sup>*</ | ||
+ | |||
+ | \\ | ||
+ | ====List sheets settings==== | ||
+ | **Description: | ||
\\ | \\ | ||
- | =====Remarks===== | + | =====Advanced options===== |
- | To use the function | + | ^Setting^Description^ |
+ | |Do not automatically offset imported range|By default, EasyMorph will align the first column and first row of imported data with column 1 and row 1\\ in the dataset. | ||
+ | |When a floating-point number can' | ||
- | If all arguments are empty values, an empty value is returned. | + | \\ |
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action: | ||
+ | * Press the "Add data" menu button. Pick "Fetch from cloud/ | ||
\\ | \\ | ||
- | =====Examples===== | + | =====See also===== |
- | | + | |
- | coalesce(empty(), | ||
- | coalesce(empty(), | ||
- | coalesce(empty(), | ||
- | \\ | ||
- | =====See also===== | ||
- | * [[syntax: | ||
- | * [[syntax: | ||
playground/playground.txt · Last modified: 2024/04/11 21:06 by craigt