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?
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.