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>
