MATLAB: Do I receive a syntax error or encounter problems when using MLGETMATRIX in Excel Link 2.0 (R13) when the sheet name contains special characters

bracketscharactercharacterscommadasherrorexcelexlinkhyphenlinkmlgetmatrixspaceSpreadsheet Linksyntax

I have an Excel spreadsheet where some sheet names contain spaces, commas, hyphens, or other special characters. When I enter the MLGETMATRIX command and specify these sheets, I receive a syntax error in Excel. The string "#SYNTAX?" is displayed in the Excel spreadsheet. In addition, MLGETMATRIX may cease to work until I close and re-open Excel.

Best Answer

This enhancement has been incorporated in Release 2006a (R2006a). For previous product releases, read below for any possible workarounds:

There is an omission in the documentation for Excel Link 2.0 (R13). The documentation should include the following information:

To access sheet names that include special characters, you must enclose the name in single quotes.

Related Solutions

MATLAB: How to read in dates stored as strings from an Excel sheet into MATLAB 7.0 (R14)

This bug has been fixed in Release 2007b (R2007b). For previous product releases, read below for any possible workarounds:

Documentation on using XLSREAD to read in string format dates is missing from the manual.

Here is additional information on performing this:

You can use the dual output syntax of XLSREAD to retrieve string format dates from an Excel file. For example, the command

[numbers dates] = xlsread('Book1.xls','Sheet1');

returns the string dates in the Excel sheet in the variable 'dates'.

For more information on the different syntaxes of XLSREAD, execute the following at the MATLAB command prompt:

doc xlsread

MATLAB: Isn’t the data sent to Excel when I use MLGetMatrix in a macro

When you use MLGetMatrix in a macro you must follow the MLGetMatrix command with the MatlabRequest command. This will update the data in Excel. Please see page 1-7 of the "Excel Link User's Guide" for more information on using MLGetMatrix in a macro:

https://www.mathworks.com/help/exlink/mlgetmatrix.html

Best Answer

Related Solutions

MATLAB: How to read in dates stored as strings from an Excel sheet into MATLAB 7.0 (R14)

MATLAB: Isn’t the data sent to Excel when I use MLGetMatrix in a macro

Related Question