Excel
For Excel the Data source properties dialog permits the .XLS file containing the data sheet to be selected using the Browse button
Once the Connection string is complete the connection may be tested by pushing the Test connection button.
To complete the dialog a “query” is required to determine what data to retrieve from the workbook. Frequently this will be the all the content of a specific worksheet. For example the string:
Select * from [Sheet1$]
returns all the data from the worksheet named Sheet1. Note that the sheet name is followed by a $ and enclosed in square bracket. Note also that AnyLabels assumes that the fieldnames are provided in the first row of the worksheet. If no fieldnames have been provided in the worksheet then unchecking the ‘Source provides fieldnames’ box will cause the fieldnames to be set to Column1, Column2, etc. but will still result in the first row of the spreadsheet NOT appearing as data.