The problem is that the excel spreadsheet is not saving the insert from the database. As matter of fact, I am not even trying to put the value from the database in yet, I am simply doing "cell.setCellValue(52);".
"Andrew C. Oliver" <[EMAIL PROTECTED]> wrote in message news:ape0g6$l04$1@;main.gmane.org... > 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>
