ExcelDataSource Properties |
The ExcelDataSource type exposes the following members.
Name | Description | |
---|---|---|
![]() | Data |
Gets or sets the Data after the ImportData method
(Inherited from DataSource.) |
![]() | DataTable |
Gets a DataTable object which represents the current imported data
(Inherited from DataSource.) |
![]() | FileName |
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
|
![]() | HasHeader |
Gets or sets a value indicating whether the data source has header.
(Inherited from DataSource.) |
![]() | Headers |
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.) |
![]() | MaxRows |
Gets or sets the maximum rows can be imported
(Inherited from DataSource.) |
![]() | RangeName |
Gets or sets RangeName according to the value of RangeType |
![]() | RangeType | |
![]() | SheetName |
Gets or sets Name of the Sheet in a SpreadSheet document.
|