Why 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?
1 view (last 30 days)
Show older comments
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.
Accepted Answer
MathWorks Support Team
on 27 Jun 2009
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.
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!