transformations:importexcel
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:importexcel [2021/04/08 23:15] – craigt | transformations:importexcel [2021/07/18 01:59] (current) – [Community examples] craigt | ||
---|---|---|---|
Line 12: | Line 12: | ||
=====Action settings===== | =====Action settings===== | ||
^ Setting | ^ Setting | ||
- | |Load file< | + | |Load file< |
- | |Source|The source of the data within the workbook. | + | |Source|The source of the data within the workbook. |
|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.| | |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.| | |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.\\ | |Parameter|Select or create the parameter containing a reference to either a sheet name or range name within the Excel file.\\ | ||
\\ | \\ | ||
- | =====Advanced options===== | + | ====Advanced options==== |
^Setting^Description^ | ^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. | |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. | ||
Line 41: | Line 41: | ||
\\ | \\ | ||
=====Remarks===== | =====Remarks===== | ||
- | **Import multiple files: | + | This action can import multiple files. |
\\ | \\ | ||
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)... | If you want it to preserve the range offset in the imported dataset (start the imported dataset in column 3, row 5)... | ||
> In " | > In " | ||
- | \\ | + | \\ \\ |
**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. | **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) | *3 rows of metadata (in rows 1-3) | ||
Line 59: | Line 59: | ||
> Columns don't have headers (checked) | > Columns don't have headers (checked) | ||
> in " | > in " | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/importexcel.txt · Last modified: 2021/07/18 01:59 by craigt