Writing into blank cells

2 次查看(过去 30 天)
James hall
James hall 2012-8-14
Hi guys,
I want my script to output certain results into an excel file, I know I can use xlswrite to do this but want to know how to set the the results to automatically appear one cell below the other - without having manually set the excel data range in xlswrite
many thanks in advance

回答(1 个)

Image Analyst
Image Analyst 2012-8-14
Well that's what happens if you send in a column vector or a 2D array. Are you not getting that? If you don't put in a range, it will put the upper left of your array at A1.
  3 个评论
Image Analyst
Image Analyst 2012-8-14
Why don't you try it? It would blast over whatever was in where you told it to write. It writes where you tell it to - it doesn't go searching for the first empty space below or to the right of some cells that may already have stuff in them. If you want to do that, you'll have to use ActiveX.
James hall
James hall 2012-8-14
That is what I want to be doing.
How would I use the Active X to do that?

请先登录,再进行评论。

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by