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/04 19:04] craigttransformations:importexcel [2021/03/04 19:05] craigt
Line 8: Line 8:
   * .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  ^
Line 35: Line 35:
 |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 this, and 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.\\ Select ... | |When a floating-point number can't be \\ converted to a fixed point number: | Options:  [ ]Produce error (default), [ ]Convert the number to text.\\ Select ... |
- 
 \\  \\ 
 =====Importing Multiple Files===== =====Importing Multiple Files=====
transformations/importexcel.txt · Last modified: 2021/07/18 01:59 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki