Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: write2excel
Date: Mon, 2 Nov 2009 13:32:02 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 28
Message-ID: <hcmn0i$b8s$1@fred.mathworks.com>
References: <hccafs$9e1$1@fred.mathworks.com> <bd524be5-63c1-49bb-9d1c-36353fe99708@g1g2000pra.googlegroups.com> <b5ff1455-26b5-4e10-94b5-25b1a8132b82@v25g2000yqk.googlegroups.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-05-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1257168722 11548 172.30.248.35 (2 Nov 2009 13:32:02 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Mon, 2 Nov 2009 13:32:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1518830
Xref: news.mathworks.com comp.soft-sys.matlab:581813


plim <manuela.cotrim@gmail.com> wrote in message <b5ff1455-26b5-4e10-94b5-25b1a8132b82@v25g2000yqk.googlegroups.com>...
> 
> Hi NZTideMan,
> 
> Do you know a way to get indx automatically from the excel file?
> 
> thanks
> Plim
> 
> 
> 
> 
> On Oct 29, 7:04?pm, NZTideMan <mul...@gmail.com> wrote:
> > On Oct 30, 3:57?am, "Teodor " <teodoralexan...@yahoo.com> wrote:
> >
> > > Hello,
> > > I have a textbox and a button. When I write a number into the textbox and push the button, I want to save that value into an excel file.
> > > Till this point it is simple, but when I want to write a new value into that box and push again the button to save the new value into the excel file, this new value it will overwrite the old one. I want to put the new value in the next row, below the old value in the excel file.
> > > Can enyone help me with this problem?
> >
> > The way I'd do it is to use the facility in xlswrite to name the cell
> > you want to place the data in. ?If you want the data to go into column
> > A, you would define an index indx=0, then do this:
> > indx=indx+1;
> > xlswrite(xlsfile,data,sheet,['A' num2str(indx)]

What I want is whenever I put the new value into the excel, I wold have to read before the excel file and get the index of the first unwritten row and write there the new value. 
Do you know how to do this?