Why this Error: Object returned error code: 0x800A01A8 is appear?
显示 更早的评论
Hi all,
While working on the actxserver i am doing some changes in excel for example :
K>> cellrange = ws.Range('C1');
K>> cellrange.Value = 'IamHere';
K>> wb.Save;
Inserted a column and write sting in a cell and saved it, That's perfect.. Then i opened Excel sheet to verify the changes were updated correctly or not. It was update fine. I closed the excel sheet and continued to perform other changes, but i am getting mentioned Error.
K>> ws.Column.Range('D').Insert;
Error: Object returned error code: 0x800A01A8
Why this error is occurring? If we open Excel sheet and again if we want to do change, again do we need to start from step1 (activating the server)?
What is the best way verify the excel sheet at the development stage of the script.
Thanks in Advance!!
采纳的回答
OCDER
2018-7-11
0 个投票
My guess is this is caused by the loss of write access to your file. To prevent both Excel and Matlab from trying to edit the same file at the same time, one program would have to give up write access. Seems like Matlab loses write access when the file is opened with Excel.
If this is true, then the fix would be to not open the file with Excel midway of a Matlab process.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Translated by 
