I use xlswrite and xlswritespec all the time. I am having a specific problem with xlswrite (see below)
4 次查看(过去 30 天)
显示 更早的评论
What I want to do is use 1 script to write to an Excel File on one sheet. After this is complete I want a second script to write additional data to a different sheet on the same file. I am getting errors when I try to perform the second write because xlswrite returns a message that says the file is now write locked. How can I get past this problem?
0 个评论
采纳的回答
Naman Chaturvedi
2018-9-20
Did you make sure that the file is not open?
xlswrite() actually launches Excel and tries to open the file. So if you have the file already opened in Excel, even though you launched it via ActiveX, you won't be able to write to it because the ActiveX process has ahold of it.
0 个评论
更多回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!