That is more or less what I am trying to do.... What I will do after I find the header is go to the cell below it and fill in data that came from a database. "Jeff Blackwell" <[EMAIL PROTECTED]> wrote in message news:JBENKKCBIOPDLCNMFHNKCEGPCBAA.jblackwell@;tenacityinc.com... > Peter - > > I'm a newbie here as well, but I may have some thoughts that can help. It > sounds like you want to do the following: > > 1) Search through an XLS file and find the a cell with a specific value > (e.g. "Header") > 2) Change that value to some other value (e.g. "Foobar") > 3) Save the XLS file back to disk. > > Is that what you're trying to do? > > -Jeff > > Jeff Blackwell > Tenacity Software, Inc. > [EMAIL PROTECTED] > www.tenacityinc.com > 916.705.0161 > > > -----Original Message----- > From: Andrew C. Oliver [mailto:andy@;superlinksoftware.com] > Sent: Friday, October 25, 2002 5:51 AM > To: POI Users List > Subject: Re: Find String value from existing excel file > > > Whoa.. You're using a printwriter on a binary file? You realize this > tries to do text conversion right? That doesn't work with binary files. > > If thats NOT what you mean, please read your message below and ask > yourself: "if I read this message would I know what the problem was?" > Information missing: what is wrong, at what point is it failing, what > do you mean by "commit the changes" and what error your getting, what > are you doing, is this in a jsp page, servlet, what? > > -Andy > > Peter Boivin wrote: > > >Andy, > >With this preexisting excel file, am I able to update a cell then commit > the > >changes? I have tried using PrintStream (using flush and close)but with no > >success. If it is possible, could you please give this newbie a clue as to > >how to go about it? > > > >-Peter > >"Andrew C. Oliver" <[EMAIL PROTECTED]> wrote in message > >news:3DB86D02.4030206@;superlinksoftware.com... > > > > > >>Not really because the logic for doing so isn't different than the logic > >>you'd have to do. (So no efficiency gain would be made) > >> > >>The method we'd have to do is to go through every cell in the workbook > >>finding the ones with that value. This isn't a very efficient thing to > >>do. Doing it with the high level API isn't really slower for this. So > >>the short answer: no, iterate through them until you find it. > >> > >>-Andy > >> > >> > >>Peter Boivin wrote: > >> > >> > >> > >>>I am working with a pre-existing excel file. I need to find a header for > >>> > >>> > >a > > > > > >>>column (ex. "Receiving"). The problem is that the header may not be on > >>> > >>> > >the > > > > > >>>first row of the excel file. I won't know the row number or the column > >>>number. Is there a way to search for a string value using poi that will > >>>return to me the row and column of the string value? > >>> > >>>Kindly, > >>>Peter > >>> > >>> > >>> > >>> > >>> > >>>-- > >>>To unsubscribe, e-mail: > >>> > >>> > ><mailto:poi-user-unsubscribe@;jakarta.apache.org> > > > > > >>>For additional commands, e-mail: > >>> > >>> > ><mailto:poi-user-help@;jakarta.apache.org> > > > > > >>> > >>> > >>> > >>> > > > > > > > > > > > >-- > >To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> > >For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > > > > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
-- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
