An XLS/XLSX Feed will parse XLS data and bring in a tabular dataset. The feed will be designated as an XLS/XLSX feed in the data pipeline, as seen in the following screenshot.

Configuring XLS/XLSX Feed

Step 1: Create a Connection

Perform the following steps to connect to a data directory on the local server:

1. Click .
   The Connections page is displayed.
2. Click + in the lower-left corner to create a new connection.
   A pop-up for choosing a connection type is displayed.
3. In the pop-up, select File / Server Filesystem connection type.
4. Click Use Selected.
   A new page is displayed.
5. In Connection Name, enter a name for the connection.
6. Make sure the Enable Connection toggle is on.
7. In Server Path, provide a relative path from the installation folder of edgeCore.
8. Click Next.
   You are taken to the Test Connection tab where the confirmation message Connection test was successful is displayed.
9. Click Save and Close.
   The newly created connection is displayed in the list of Connections.

Step 2: Create an XLS/XLSX Feed

Now that you have established a connection to a directory of files, you can create a Feed from a specific XLS/XLSX file.

Perform the following steps to create a Feed from a specific XLS/XLSX data file:

1. Click .
   The connection you created is displayed in the Pipeline.
2. Click the gear icon button in the connection box and select + .
   A pop-up for choosing a Feed Type is displayed.
3. In the pop-up, select XLS/XLSX.
   A new page is displayed.
4. On the Base Configuration tab, do the following:
   a) In Feed Name, enter a name for the feed.
   b) (Optional) Provide a description.
   c) In File Name, select the .xml file. In order for the XLS/XLSX file to appear in this dropdown, it needs to be located in the data folder of the edgeCore build.
   d) Enable or disable the Preserve Data Types toggle switch. If enabled, data types defined in the data source will be preserved. If disabled, all values will be interpreted as strings.
   e) Enable or disable the Evaluate Formulas toggle switch. If enabled, data will contain formula results. If disabled, data will contain the formula string.
   f) (Optional) Enable the Advanced Update Scheduling toggle switch if you want to define an advanced schedule for updates.
   g) In Poll Interval, specify how often you can access the data for a feed and also how often the data changes (in seconds). If a server subscription is active (another user is using that node or a server job is making it active), the current data retrieved will be returned. It will not refresh until all server-side subscriptions are closed and a new one is open. If you set the poll interval to 0, that means the data is very static, and you do not expect it to change.
   h) (Optional) Turn on the Enable Server Subscription toggle switch in order for data for this feed to be continually fetched, updated, and cached based on the Poll Interval. If enabled, the server will subscribe to the feed, just as a client widget would. This means that the data and any resources that would otherwise be allocated “on-demand” for the first user to view a Visualization that leverages the data produced by this feed are allocated when the server is started and maintained as long as this feed is configured.
   i) (Optional) Enable the Persist toggle switch to use persistent table store.
   j) (Optional) Enable the Publish Dataset via REST API toggle switch to allow other edgeCore servers or third-party software to connect to this server’s pipeline.
   k) Click Next. You are taken to the Select XLS Sheet tab.
5. On the Select XLS Sheet tab, do the following:
   a) In Sheet Name, select a sheet from the XLS/XLSX file.
   Attributes from the sheet are displayed in a table.
   b) Click Next.
   You are taken to Data Preview where you can observe the data preview of your XLS/XLSX Feed.
   
6. Click Save and Close.
   The newly created feed is displayed in the Pipeline.

Uploading XLS/XLSX Files through the User Interface

edgeCore version: 4.3.7

To upload XLS/XLSX files to feeds without having to access the server, click + next to File Name.
Make sure the file extension matches the feed type (in this case, the extension needs to be .xls or .xlsx).
Once uploaded, the XLS/XLSX file will be available in the File Name dropdown.