Differences

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

--- transformations:importexcel [2021/07/13 12:46] – [Examples] craigt
+++ transformations:importexcel [2021/07/13 12:50] – craigt
@@ Line 12: / Line 12: @@
 =====Action settings=====
 ^ Setting  ^ Description  ^
-|Load file<sup>*</sup>|Fully-qualified file name of the Excel workbook (includes relative or absolute path).|
+|Load file<sup>*</sup>| Fully qualified file name of the Excel workbook (includes relative or absolute path).|
-|Source|The source of the data within the workbook.  Options include: //Worksheet names//, //Range names//, \\ //Worksheet positions//, and //Worksheet/range defined by parameter//.  See table below for option settings.|
+|Source|The source of the data within the workbook.  Options include: //Worksheet names//, //Range names//, \\ //Worksheet positions//, and //Worksheet/range defined by parameter//.  See the table below for option settings.|
 |Select sheet name(s)|Once the Excel file has been selected, a list of worksheets within the file will display, allowing you to select\\ which worksheets to import.|
 |Add column with sheet name|Check this box to add a column to the dataset that lists the name of the worksheet the data was imported from.|
@@ Line 34: / Line 34: @@
 |Parameter|Select or create the parameter containing a reference to either a sheet name or range name within the Excel file.\\  Note: sheet names are searched for before range names, in cases where sheets and ranges have been given the same names.|
 \\
-=====Advanced options=====
+====Advanced options====
 ^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.|
@@ Line 50: / Line 50: @@
 If you want it to preserve the range offset in the imported dataset (start the imported dataset in column 3, row 5)...
 >  In "Advanced settings", Do not automatically offset imported range (checked)\\
-\\
+\\ \\
 **Example 2:**  You're importing data from an Excel spreadsheet with the following properties, and you want the data to start at column 1, row 1 in the imported dataset.
   *3 rows of metadata (in rows 1-3)