User Tools

Site Tools


transformations:importexcel

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:importexcel [2021/03/12 21:21] – [Advanced Options] craigttransformations:importexcel [2021/04/08 23:15] craigt
Line 1: Line 1:
 {{ transformations:ImportExcelAction.png}} {{ transformations:ImportExcelAction.png}}
 ====== IMPORT EXCEL SPREADSHEET ====== ====== IMPORT EXCEL SPREADSHEET ======
-Category: Import / File+Category: Import / File\\
  
 +\\ 
 =====Description===== =====Description=====
 This action loads data from an Excel file. Supported formats: 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 )
 +
 \\  \\ 
 =====Action settings===== =====Action settings=====
 ^ Setting  ^ Description  ^ ^ Setting  ^ Description  ^
-|Load file|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 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.| |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<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| |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 all columns|This option imports all columns in the spreadsheet.|
 |Load only selected columns|This option allows you to select which columns to import.  A list of columns found in the spreadsheet will be\\ presented for you to select.| |Load only selected columns|This option allows you to select which columns to import.  A list of columns found in the spreadsheet will be\\ presented for you to select.|
  
 +<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
 +\\ 
 ====Source settings==== ====Source settings====
 ^Setting^Description^ ^Setting^Description^
Line 31: 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.| |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^ ^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.| |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//.| |When a floating-point number can't\\ be converted to a fixed point number: | Options:  //Produce error (default)//, //Convert the number to text//.|
 +
 \\  \\ 
-=====Importing multiple files===== +=====Remarks===== 
-This action can import multiple files.  See [[import:fileimportmodes|Importing Multiple Files]] for more information.\\+**Import multiple files:**  This action can import multiple files.  See [[import:fileimportmodes|Importing Multiple Files]] for more information.\\
  
 \\  \\ 
Line 55: Line 59:
 >  Columns don't have headers (checked) >  Columns don't have headers (checked)
 >  in "Advanced settings", Do not automatically offset imported range (unchecked) >  in "Advanced settings", Do not automatically offset imported range (unchecked)
 +
 +\\ 
 +=====Shortcuts=====
 +Fast ways to create the action:
 +  * Press the "Add data" menu button. Pick "Import file" or "Import multiple files".
 +  * 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=====+=====See also=====
  
   * [[transformations:exportexcel|Export into Excel file]]   * [[transformations:exportexcel|Export into Excel file]]
  
  
transformations/importexcel.txt · Last modified: 2021/07/18 01:59 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki