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 次查看（过去 30 天）
MathWorks Support Team
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.

请先登录，再回答此问题。

采纳的回答

MathWorks Support Team
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by