From: james bejon on
Could someone give me some tips on how best to interact with Excel (03)?

I want to read some data from a book (I know its name and sheet names), process the data, and then write it back to the same book.

I can read data whether the book is open or not (via xlsread), but I can only write to it when it's closed (via xlswrite). Is this normal? If so, what's the best solution? Are handles helpful here? Is there a way of closing a workbook via Matlab, etc?