okay so what exactly is the problem? Peter Boivin wrote:
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" 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" 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:
>>>>
>>>>
>>
>>
>>
>>
>>>>For additional commands, e-mail:
>>>>
>>>>
>>
>>
>>
>>
>>>>
>>>>
>>>>
>>
>>
>>
>>
>>--
>>To unsubscribe, e-mail:
>>For additional commands, e-mail:
>>
>>
>>
>
>
>--
>To unsubscribe, e-mail:
>For additional commands, e-mail:
-- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
