Click or drag to resize

ExcelDataSource Properties

The ExcelDataSource type exposes the following members.

Properties
  NameDescription
Protected propertyData
Gets or sets the Data after the ImportData method
(Inherited from DataSource.)
Public propertyDataTable
Gets a DataTable object which represents the current imported data
(Inherited from DataSource.)
Public propertyFileName
Gets or sets the File name which to import the data. If HasHeader is set to , the first row of excel data is considered as headers
Public propertyHasHeader
Gets or sets a value indicating whether the data source has header.
(Inherited from DataSource.)
Public propertyHeaders
Gets or Sets the headers. if the file data source contains header (for example, The first row of a CSV the headers), headers will be refilled after the call of ImportData. The headers can be used as an variable. For example, the token ${name} will be replace by the value where the header name is "name"
(Inherited from DataSource.)
Public propertyMaxRows
Gets or sets the maximum rows can be imported
(Inherited from DataSource.)
Public propertyRangeName
Gets or sets RangeName according to the value of RangeType
Public propertyRangeType
Gets or sets RangeType. When using NamedRange or Table, SheetName will be ignored.
Public propertySheetName
Gets or sets Name of the Sheet in a SpreadSheet document.
Top
See Also