[
https://issues.apache.org/jira/browse/DRILL-7177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16952926#comment-16952926
]
ASF GitHub Bot commented on DRILL-7177:
---------------------------------------
arina-ielchiieva commented on pull request #1749: DRILL-7177: Format Plugin for
Excel Files
URL: https://github.com/apache/drill/pull/1749#discussion_r335540172
##########
File path: contrib/format-excel/README.md
##########
@@ -0,0 +1,36 @@
+# Excel Format Plugin
+This plugin enables Drill to read Microsoft Excel files. This format is best
used with Excel files that do not have extensive formatting, however it will
work with formatted files, by allowing you to define a region within the file
where the data is.
+
+The plugin will automatically evaluate cells which contain formulae.
+
+## Plugin Configuration
+This plugin has several configuration variables which must be set in order to
read Excel files effectively. Since Excel files often contain other elements
besides data, you can use the configuration variables to define a region within
your spreadsheet in which Drill should extract data. This is potentially
useful if your spreadsheet contains a lot of formatting or other complications.
+
+* `headerRow`: Set to -1 if there are no column headers.
+* `lastRow`: This defines the last row of your data. The default is an
arbitrary large number. You only will need to set this if you want Drill to
stop reading at a specific location.
Review comment:
Can you please specify exact number?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Format Plugin for Excel Files
> -----------------------------
>
> Key: DRILL-7177
> URL: https://issues.apache.org/jira/browse/DRILL-7177
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.17.0
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Labels: doc-impacting
> Fix For: 1.17.0
>
>
> This pull request adds the functionality which enables Drill to query
> Microsoft Excel files.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
