You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hop.apache.org by ha...@apache.org on 2020/12/29 10:49:29 UTC
[incubator-hop-docs] branch asf-site updated: Update excelinput.adoc
This is an automated email from the ASF dual-hosted git repository.
hansva pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/incubator-hop-docs.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 815ac70 Update excelinput.adoc
new 4a9c746 Merge pull request #29 from nadment/patch-2
815ac70 is described below
commit 815ac7090a3fae4456664fd4f9bd801e9ffc741d
Author: Nicolas Adment <39...@users.noreply.github.com>
AuthorDate: Tue Dec 29 11:28:41 2020 +0100
Update excelinput.adoc
---
.../modules/ROOT/pages/plugins/transforms/excelinput.adoc | 7 +++----
1 file changed, 3 insertions(+), 4 deletions(-)
diff --git a/hop-user-manual/modules/ROOT/pages/plugins/transforms/excelinput.adoc b/hop-user-manual/modules/ROOT/pages/plugins/transforms/excelinput.adoc
index dc8599c..b365226 100644
--- a/hop-user-manual/modules/ROOT/pages/plugins/transforms/excelinput.adoc
+++ b/hop-user-manual/modules/ROOT/pages/plugins/transforms/excelinput.adoc
@@ -17,11 +17,10 @@ The default spreadsheet type (engine) is set to Excel 97-2003 XLS. When you are
|===
|Option|Description
|transform Name|Name of the transform; the name has to be unique in a single transform.
-|Spread sheet type (engine) a|This field allows you to specify the spreadsheet type. (since version 4.1.0) Currently the following are supported:
+|Spread sheet type (engine) a|This field allows you to specify the spreadsheet type. Currently the following are supported:
-* Excel 97-2003 XLS: this is the default, backward compatible type provided for by the JXL software backend.
-* Excel 2007 XLSX (Apache POI): If you select this spread sheet type you can read all known Excel file types. Functionality provided by the Apache POI project.
-* Excel 2007 XLSX (Apache POI Streaming): This spread sheet type allows to read in large Excel files (Experimental in 5.1).
+* Excel XLSX, XLS: This is the default, if you select this spread sheet type you can read all known Excel file types. Functionality provided by the Apache POI project.
+* Excel XLSX (Streaming): This spread sheet type allows to read in large Excel files.
* Open Office ODS: By selecting this type you can read OpenOffice spreadsheet using the ODFDOM engine.
|File or directory|Specifies the location and/or name of the input text file. Note: Click Add to add the file/directory/wildcard combination to the list of selected files (grid) below.
|Regular expression|Specify the regular expression you want to use to select the files in the directory specified in the previous option. For example, you want to process all files that have a .txt extension. (For further details see the Text File Input transform and the section "Selecting file using Regular Expressions")