using XLSread on virtual machine

2 次查看（过去 30 天）

Still Learning Matlab 2018-7-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411135-using-xlsread-on-virtual-machine

评论： Harsh 2018-7-20

I am using a virtual Windows 10 Machine (accessing through windows RDC) and am having trouble executing the xlsread function.

I have copied and pasted a working version of the excel spreadsheet to the VM, and have ensured that I can open and edit it (no issues with Excel that I can identify). When running xlsread (i have run the script which contains this line countless times on my physical machine with no error) I receive the following

error:Error using xlsread (line 260)
Excel Worksheet could not be activated.

Running xlsfinfo I get:

ans =
    0×0 empty char array

Does anyone have an idea of what might be causing this, and how to fix it? Thanks in advance

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Harsh 2018-7-20

This post might be helpful: https://www.mathworks.com/matlabcentral/answers/305976-error-using-xlsread-line-249-excel-worksheet-could-not-be-activated

You can also consider using 'xlsread' in 'basic' mode.

请先登录，再进行评论。

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

回答（0 个）

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

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

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

产品

MATLAB

版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by