Could you include a code snippet of what you're trying? And what's not working. If you're setting the cell value as described below, and writing the workbook back out, then only problem remaining is if the workbook doesn't open when you open it in Excel. Or are you getting an error on the call to setCellValue?
-Jeff -----Original Message----- From: news [mailto:news@;main.gmane.org]On Behalf Of Peter Boivin Sent: Saturday, October 26, 2002 2:49 PM To: [EMAIL PROTECTED] Subject: Re: Find String value from existing excel file 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> -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
