User confirmation needed
Excel to Database configuration
Table Name
*
Name of table to be created from excel data.
Excel File
*
Select a Excel file to be uploaded to a database.
Sheet Name
Strings used for sheet names (default is the first sheet).
Database
Schema
Specify a schema (if database flavor supports this).
Table Exists
*
Fail
Replace
Append
If table exists do one of the following: Fail (do nothing), Replace (drop and recreate table) or Append (insert data).
Header Row
Row containing the headers to use as column names (0 is first line of data). Leave empty if there is no header row.
Index Column
Column to use as the row labels of the dataframe. Leave empty if no index column.
Mangle Duplicate Columns
Specify duplicate columns as "X.0, X.1".
Skip Rows
Number of rows to skip at start of file.
Rows to Read
Number of rows of file to read.
Parse Dates
A comma separated list of columns that should be parsed as dates.
Decimal Character
Character to interpret as decimal point.
Dataframe Index
Write dataframe index as a column.
Column Label(s)
Column label for index column(s). If None is given and Dataframe Index is True, Index Names are used.
Null values
Json list of the values that should be treated as null. Examples: [""], ["None", "N/A"], ["nan", "null"]. Warning: Hive database supports only single value. Use [""] for empty string.
Save
Back
