transformations:importexcel
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:importexcel [2015/04/17 08:57] – dmitry | transformations:importexcel [2021/07/13 12:46] – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Import from Excel file ===== | + | {{ transformations: |
- | + | ====== IMPORT EXCEL SPREADSHEET ====== | |
- | This transformation loads data from an Excel file. Supported formats: | + | Category: Import / File\\ |
+ | \\ | ||
+ | =====Description===== | ||
+ | This action loads data from an Excel file. Supported formats: | ||
* .xlsx (Excel 2007 or later) | * .xlsx (Excel 2007 or later) | ||
* .xls (Excel 95 - Excel 2003 ) | * .xls (Excel 95 - Excel 2003 ) | ||
- | File name should include full or relative path. | + | \\ |
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |Load file< | ||
+ | |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.| | ||
+ | |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< | ||
+ | |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 spreadsheet.| | ||
+ | |Load only selected columns|This option allows you to select which columns to import. | ||
+ | |||
+ | < | ||
+ | \\ | ||
+ | ====Source settings==== | ||
+ | ^Setting^Description^ | ||
+ | |// | ||
+ | |Select sheet name(s)|Select from the list which sheets to import. | ||
+ | |//**Range name settings**// | ||
+ | |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.). | ||
+ | |// | ||
+ | |Parameter|Select or create the parameter containing a reference to either a sheet name or range name within the Excel file.\\ | ||
+ | \\ | ||
+ | =====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. | ||
+ | |When a floating-point number can' | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | This action can import multiple files. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example 1:** You're importing a data range spanning cells C5 to E10:\\ \\ | ||
+ | To start at column 1, row 1 in the imported dataset... | ||
+ | > In " | ||
+ | If you want it to preserve the range offset in the imported dataset (start the imported dataset in column 3, row 5)... | ||
+ | > 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. | ||
+ | *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 " | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action: | ||
+ | * Press the "Add data" menu button. Pick " | ||
+ | * Drag an Excel file into the application window. Supported file extensions: .xls, .xlsx | ||
+ | * Drag a folder with Excel files into the application window. | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |||
+ | * [[transformations: | ||
transformations/importexcel.txt · Last modified: 2021/07/18 01:59 by craigt