Skip to main content

ExcelSourceOptions Members

Contains options used to extract data from the Microsoft Excel workbook.

Constructors

Name Description
ExcelSourceOptions() Initializes a new instance of the ExcelSourceOptions class.
ExcelSourceOptions(ExcelSettingsBase) Initializes a new instance of the ExcelSourceOptions class with the specified import settings.

Properties

Name Description
ImportSettings Gets or sets settings used to import data from the Microsoft Excel workbook.
Password Gets or sets the password used to access the protected workbook.
SkipEmptyRows Gets or sets whether or not to include empty rows into the resulting ExcelDataSource. Inherited from ExcelSourceOptionsBase.
SkipHiddenColumns Gets or sets whether to ignore hidden columns when importing data to ExcelDataSource.
SkipHiddenRows Gets or sets whether to ignore hidden rows when importing data to ExcelDataSource.
UseFirstRowAsHeader Gets or sets whether to process the values of the first row as headers. Inherited from ExcelSourceOptionsBase.

Methods

Name Description
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current ExcelSourceOptions instance.
GetHashCode() Gets the hash code that corresponds to the value of the current ExcelSourceOptions object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also