Skip to main content

ExcelSourceOptions Properties

Contains options used to extract data from the Microsoft Excel workbook.
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.
See Also