Differences

This shows you the differences between two versions of the page.

--- playground:playground [2021/09/13 00:03] – craigt
+++ playground:playground [2023/11/03 12:11] – add List sheets description craigt
@@ Line 1: / Line 1: @@
-===== Empty() =====
+{{ transformations:ImportGoogleSheetsAction.png}}
-Category:  Special function
+====== IMPORT  GOOGLE SHEETS======
+Category: Import / App/Cloud\\
 \\
 =====Description=====
-This function creates an [[syntax:types#empty_values|empty value]].
+Import data from a Google Sheets file.\\
 \\
-=====Use cases=====
+===== Action settings =====
-Use //empty()// to insert empty values into cells, or within other functions.
-\\
+^ Setting  ^ Description ^
-=====Arguments=====
+|Connector<sup>*</sup>| A configured connector to Google Drive.  See [[connectors:googledrive|Google Drive connector]].  |
-This function does not require arguments.
+|Spreadsheet<sup>*</sup>| The path to the source Google Sheet document.  This is set after the //Connector// is created.  |
+|Import action|Options:  //Import table// (retrieve data from a sheet, see details below) or //List sheets// (produce a list of sheet names within the Sheets file).|
-**Return value type:** Empty value
+\\
+==== Import table settings ====
+^ Setting  ^ Description ^
+|Sheet or range<sup>*</sup>| Sheet or range to be imported.  This list will be populated once the //Connector// is set and the //Spreadsheet// is selected.  |
+|Skip first lines<sup>*</sup>|The number of rows to skip before reading in your data.  If your data does not start on the first row\\ (i.e., leading rows with metadata, blank rows), use this setting to skip these rows.|
+|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.  A list of columns found in the sheet will be\\ presented for you to select.|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+====List sheets settings====
+**Description:**  Produce a list of sheet names within the selected Sheets file.  There are no settings required for this action.
 \\
-=====Remarks=====
+=====Advanced options=====
-While a value can be tested for an empty value using a "value = empty()" expression, the [[syntax:functions:isempty|IsEmpty]] function can also be used.  The two approaches are equivalent.
+^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.  To prevent this, and to preserve the actual positioning of data within the source file, //check// this option.|
+|When a floating-point number can't\\ be converted to a fixed point number: | Options:  //Produce error (default)//, //Convert the number to text//.|
 \\
-=====Examples=====
+=====Shortcuts=====
+Fast ways to create the action:
+  * Press the "Add data" menu button. Pick "Fetch from cloud/application".
-  [Content] = empty()  //Returns TRUE if [Content] contains an empty value, otherwise, FALSE.
+\\
+=====See also=====
+  *[[connectors:googledrive|Google Drive connector]]
-  coalesce(empty(), 'ABC', '')  //Using empty() as an argument within a function.
-  if( [Value] = 10, 'Ten', empty() )  //Using empty() to set an empty value in an If statement.
-\\
-=====See also=====
-  * [[syntax:functions:isempty|IsEmpty(expression)]]
-  * [[syntax:types|The EasyMorph Type system]]