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/17 22:10] – craigt | playground:playground [2023/11/03 12:11] – add List sheets description craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | {{ transformations: |
- | Category: | + | ====== |
+ | Category: | ||
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | This function decodes | + | Import data from a Google Sheets file.\\ |
\\ | \\ | ||
- | =====Arguments===== | + | ===== Action settings |
- | ^Argument^Type^Description^ | + | |
- | |method | + | ^ Setting |
- | |text |Text |The text string | + | |Connector< |
- | **Return value type:** Text. | + | |Spreadsheet< |
+ | |Import action|Options: | ||
+ | |||
+ | \\ | ||
+ | ==== 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:** | ||
\\ | \\ | ||
- | ^Method | + | =====Advanced options===== |
- | |' | + | ^Setting^Description^ |
- | |'Base64' | + | |Do not automatically offset imported range|By default, EasyMorph will align the first column |
- | |' | + | |When a floating-point number can't\\ be converted to a fixed point number: |
\\ | \\ | ||
- | =====Examples===== | + | =====Shortcuts===== |
- | | + | Fast ways to create the action: |
+ | | ||
\\ | \\ | ||
=====See also===== | =====See also===== | ||
- | * [[syntax:functions: | + | *[[connectors:googledrive|Google Drive connector]] |
- | * [[syntax: | + | |
- | * [[syntax: | + | |
+ | |||
playground/playground.txt · Last modified: 2024/04/11 21:06 by craigt