How to use xlswrite in an Excel add-in?
1 view (last 30 days)
Show older comments
Hello,
I am using EX Builder to make an Excel add-in. The add-in should read an m x n matrix from the sheet and write down an m x 3 matrix of outputs. Now, I am OK with the first part which consists of using the xlsread function. However, I am having an issue using the xlswrite function which cannot write into an opened workbook. Is there a way to work around this problem?
Many thanks!
P.S. I did try to include a piece of code which closes the workbook before applying xlswrite. This works when I run my m file in Matlab, however it still does not work when I build an Excel add-in.
1 Comment
Jan Eikeset
on 15 Jul 2016
Has anybody found an answer to this question? I find myself in a similar situation.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!