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.
Best Answer