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.
|