Got Questions? Get Answers.
Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
xlswrite to next available cell

Subject: xlswrite to next available cell

From: Meaghan

Date: 28 May, 2013 19:18:11

Message: 1 of 2

I am trying to create a database of sorts in which the GUI user can input data regularly. Is there a way to have xlswrite automatically write the information into the next available cell?

For example: If column N is for number of bacteria in a test, and N1 is filled with last week's data, can I make matlab recgonize N2 has being the point of entry? And continue to do so for N3, N4, etc. for subsequent weeks? I don't want to have to update my script everyweek with N3, N4, etc.

So far I have this in the callback of the edit text box:

number = get(handles.numbenter,'String')
 xlswrite('filename',number,'Sheet1','[what do I put here?]')

Let me know if I need to clarify.

Thanks!

Subject: xlswrite to next available cell

From: Image Analyst

Date: 30 May, 2013 01:05:09

Message: 2 of 2

No there is not. To do that you need to use Active X. Go over to the Answers forum ( http://www.mathworks.com/matlabcentral/answers/) and search for ActiveX where you'll find lots of demos.

Tags for this Thread

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us