XLS and XLSX data sources read a file in the Microsoft Excel XLS or XLSX format and allow you to query its contents as a relational table. These data sources support features domain-related features like returning JDBC metadata, creating derived tables, supporting calculated fields, domain pre-filtering, joining other data sources in a virtual data source, and full support in the Domain Designer.
To create an XLS or XLSX data source:
|1.||Log on as an administrator.|
|2.||Click View > Repository, expand the folder tree, and right-click a folder to select Add Resource > Data Source from the context menu.
|3.||In the Type field, select either the XLS or XLSX data source. In this example, we create an XLSX data source.|
File Data Source Page for a JSON Data Source
|4.||Enter the date and time format patterns used for the data source.|
|5.||Enter the file path for the XLSX file. You can specify a file in the repository with the repo: syntax, followed by the repository path of the file. Specify ftp:, http: or https: to use those Internet protocols. To specify a file on your server's file system, specify its path directly, starting from the root, for example /tmp/MyDataFile.xlsx. The user running the server process must have permission to access the file.|
|6.||Enter the regional locale for the file. The locale property displays the data in a specific format based on the region.|
|7.||Enter the number pattern for the file.|
|8.||Enter the name of the Excel file sheet to use for the data source.|
|9.||Enter the local time zone for the file.|
|10.||Specify whether the first row in the XLSX file is a header as true or false.|
|11.||Click Save. The Save dialog appears.|
|12.||Enter a name for the data source and an optional description. The Resource ID is generated from the name you enter. If you haven't already specified a location, expand the folder tree and select the location for your data source.|
|13.||Click Save in the dialog. The data source appears in the repository.|