Why am I not able to see any data in the "Tables" field when I connect to an Excel database (.xls file)?

Why am I not able to see any data in the "Tables" field when I connect to an Excel database (.xls file)?

I followed all the steps to create a connection to a .xls file (Excel Database) from MATLAB. I am able to locate my .xls file as a data source. However, I am unable to see any of the data I stored in the .xls file displayed in the "Tables" field. In fact, the "Tables" field is blank.

Answer 1

[MathWorks Support Team]

To be able to see tables outside Excel, you need to label the columns of data inside Excel. This can be done by doing the following:

1. Select the column(s)/row(s) of data to be labeled.

2. Go to Insert-->Name --> Define and make a label for the selection.

3. Save this setting.

4. You should now be able to read the columns from the Excel Sheet from MATLAB using QUERYBUILDER.

NOTE: It does not matter if the first row of a column has a name and the other columns have numbers. You need to explicitly name these columns so that they can be read from other programs as tables in the database.