transformations:importexcel
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:importexcel [2021/03/04 19:04] – craigt | transformations:importexcel [2021/07/13 12:50] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{ transformations: | {{ transformations: | ||
- | ===== IMPORT | + | ====== IMPORT EXCEL SPREADSHEET ====== |
- | (Category: //Import | File//) | + | Category: |
+ | \\ | ||
=====Description===== | =====Description===== | ||
- | This transformation | + | This action |
* .xlsx (Excel 2007 or later) | * .xlsx (Excel 2007 or later) | ||
* .xls (Excel 95 - Excel 2003 ) | * .xls (Excel 95 - Excel 2003 ) | ||
+ | \\ | ||
=====Action settings===== | =====Action settings===== | ||
^ Setting | ^ Setting | ||
- | |Load file|Fully-qualified file name of the Excel workbook (includes relative or absolute path).| | + | |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.| | ||
- | |Skip first lines|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.| | + | |Skip first lines< |
|Columns don't have headers|Check this if your dataset does not include a row with header information| | |Columns don't have headers|Check this if your dataset does not include a row with header information| | ||
- | |Load all columns|This option imports | + | |Load all columns|This option imports all columns in the spreadsheet.| |
|Load only selected columns|This option allows you to select which columns to import. | |Load only selected columns|This option allows you to select which columns to import. | ||
- | ^**//Source settings//**^^ | + | <sup>*</sup> Setting can be specified using a [[: |
+ | \\ | ||
+ | ====Source settings==== | ||
^Setting^Description^ | ^Setting^Description^ | ||
|// | |// | ||
Line 27: | Line 30: | ||
|Select range name(s)|Select which named ranges within the Excel file to import. | |Select range name(s)|Select which named ranges within the Excel file to import. | ||
|// | |// | ||
- | |Select sheet position(s)|Select which sheets to import based on their **position** within the Excel file (1st, 2nd, etc.). | + | |Select sheet position(s)|Select which sheets to import based on their position within the Excel file (1st, 2nd, etc.). |
|// | |// | ||
|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 | + | ====Advanced |
^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.\\ To prevent this, and preserve the actual positioning of data within the source file, **check** this option.| | + | |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' | + | |When a floating-point number can' |
\\ | \\ | ||
- | =====Importing Multiple Files===== | + | =====Remarks===== |
- | This action can import multiple files. | + | This action can import multiple files. |
\\ | \\ | ||
=====Examples===== | =====Examples===== | ||
**Example 1:** You're importing a data range spanning cells C5 to E10:\\ \\ | **Example 1:** You're importing a data range spanning cells C5 to E10:\\ \\ | ||
- | //To start at column 1, row 1 in the imported dataset...// | + | To start at column 1, row 1 in the imported dataset... |
- | <code> | + | > In "Advanced settings", |
- | </ | + | 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 "Advanced settings", |
- | <code> | + | \\ \\ |
+ | **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) | ||
+ | *The data starts at column C | ||
+ | *There are no headers | ||
+ | Use the following settings: | ||
+ | > Skip the first 3 lines | ||
+ | > Columns don't have headers (checked) | ||
+ | > in " | ||
\\ | \\ | ||
- | **Example | + | ====Community examples==== |
- | < | + | |
- | Columns don't have headers = "checked" | + | * [[https:// |
- | (Advanced settings) Do not automatically offset imported range = "unchecked" | + | * [[https:// |
- | </ | + | |
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action: | ||
+ | * Press the "Add data" | ||
+ | * Drag an Excel file into the application window. Supported file extensions: .xls, .xlsx | ||
+ | * Drag a folder with Excel files into the application window. | ||
\\ | \\ | ||
- | =====See | + | =====See |
* [[transformations: | * [[transformations: | ||
transformations/importexcel.txt · Last modified: 2021/07/18 01:59 by craigt