JDBC Driver for Microsoft Excel

Build 22.0.8462

Data

This section provides a complete list of the Data properties you can configure in the connection string for this provider.


PropertyDescription
AllowFormulaWhether or not to treat values starting with an equals (=) sign as formulas during inserts and updates.
EmptyValueModeIndicates whether to read the empty values as empty or as null.
NullValuesA comma separated list which will be replaced with nulls if there are found in the CSV file.
IgnoreCalcErrorIndicates whether to ignore errors that occurred during the calculation.
NullValueModeIndicates whether to read empty cells as null or as empty.
HasCrossSheetReferencesIndicates how cross sheet references are handled.
RecalculateIndicates whether to recalculate all formulas when data is read.
ShowEmptyRowsIndicates whether or not the empty rows should be pushed.
TypeDetectionSchemeDetermines how the provider detects the data types of columns.
EnableOleDbCompatibilityIndicates whether to read the data with the same behavior as the Microsoft OleDB driver.
UseFastInsertIndicates whether to use the fastInsert when executing Insert Statement.
SkipTopSkips the number of rows specified starting from the top.
IncludeCustomNamesIndicates whether or not the defined names should be pushed.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462