MATLAB: Am I not able to see any data in the “Tables” field when I connect to an Excel database (.xls file)

connectdatabaseDatabase Toolboxexceltablexls

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.

Best Answer

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.

Related Solutions

MATLAB: Does QUERYBUILDER ask for a username and password when using an Excel File data source with no worksheet specified in Database Toolbox 3.3 (R2007a)

This is the expected behavior when no workbook is specified.

To work around this issue, specify a Workbook before using the Excel File data source. To do this:

1. From the Visual Query Builder, select File (Query for newer versions of MATLAB)->Define ODBC Data Sources.

2. Select Excel Files, and click Configure.

3. Click Select Workbook and pick your XLS-file.

4. Click OK, then OK.

You should now be able to use the Excel Files datasource.

In general, when a database connection fails, the Query Builder then attempts to reconnect with a username and password, as this is the cause of most failures with most databases. Attempting to connect to an unspecified Excel file triggers this behavior.

MATLAB: Finding how many folders are in an other folder and how many files (.xls files) are in each folder

FolderA='C:\mydocument\c';
f=dir(FolderA)

will give you a list of files and folders. Checking f.isdir will tell you how many are folders. Note that f(1) and f(2) are usually '.' and '..'

Files=dir(fullfile(FolderA,'b\*.xls')) will tell you how many .xls files are in the \b folder.

Best Answer

Related Solutions

MATLAB: Does QUERYBUILDER ask for a username and password when using an Excel File data source with no worksheet specified in Database Toolbox 3.3 (R2007a)

MATLAB: Finding how many folders are in an other folder and how many files (.xls files) are in each folder

Related Question