Writing into blank cells

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

Answer 1

[Image Analyst]

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.

[James hall]

so if I was to set the range for example A1:A20, and A1-A5 were full in the excel document then it would automatically write to A6?

[Image Analyst]

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]

That is what I want to be doing.

How would I use the Active X to do that?