|
| CellRange | | A range of cells from the worksheet to include in the data.
Examples:
A1:H10
will include rows 1 through 10 of columns A through H
C:F
will include all data rows from columns C, through F.
|
| ColumnNames | | A list of column names, separated by commas. For example:
OrderID, CustomerID, EmployeeID, OrderDate |
| ColumnNamesRow | | The row number which contains the names for the data columns.
This row will not be included in the data, but will be used as data column names when the data is valid (names should start with a letter and include only letters or numbers). |
| DateColumns | | A comma-delimited list of columns that should be displayed as dates.
Column names should match those used in the datalayer: either the default names (Column1, Column2), or names defined in a row of the source data, or custom names defined in the Column Names attribute. |
| ExcelFile | | (Required) The location of the Excel file. This may be a local path, such as:
D:\Data\records.xls
It may also be the full URL to an Excel file on the Internet, such as:
http://www.example.com/data/records.xls
Excel 2007 (.xlsx) and earlier versions (.xls) are supported. |
| ExcelWorksheet | | Specifies the worksheet from which to retrieve data in the Excel file.
If not given, the default value is the first worksheet. |
| ID | | The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |