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/10 16:58] – [Importing Multiple Files] craigttransformations:importexcel [2021/03/12 21:21] – [Advanced Options] craigt
Line 4: Line 4:
  
 =====Description===== =====Description=====
-This transformation 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)
Line 33: Line 33:
 =====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 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 thisand 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//.|
 \\  \\ 
transformations/importexcel.txt · Last modified: 2021/07/18 01:59 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki