That's what I'd use POI/HSSF for... to build the Excel stuff in Java. Maybe I'm off base, but I think that's probably what he did... Again, it's all Monday morning quarterbacking... If he were going ODBC , what you're saying makes sense.
Regards, Jeff -----Original Message----- From: Andrew C. Oliver [mailto:acoliver@;apache.org] Sent: Sunday, November 03, 2002 9:00 AM To: poi users Subject: RE: Using Borland's QueryDataSet to send to Excel Does the JDBC stuff not have to go through ODBC to get to Excel? And does not the ODBC driver require Excel native binaries? -Andy On Sun, 2002-11-03 at 00:55, Jeff Blackwell wrote: > Maybe I'm missing something... The QueryDataSet that he's referring to > should be pure Java, no? Why wouldn't it work on Linux? Maybe you were > thinking of their Delphi components or something? IIRC, the stuff he's > referring to are just Java wrappings around JDBC. They just make it easier > to bind screen controls to a DB. With Swing, that's usually a bad idea, so > they don't get used a lot, in my experience. They should be portable, but > are no doubt slower, due to the extra goo involved. I still prefer to use > straight old JDBC myself. No biggie... > > Have a good weekend! > > -Jeff > > -----Original Message----- > From: Andrew C. Oliver [mailto:acoliver@;apache.org] > Sent: Saturday, November 02, 2002 1:12 PM > To: POI Users List > Subject: Re: Using Borland's QueryDataSet to send to Excel > > > ;-) But it doesn't work too well on my linux box ;-) > > Jeff Blackwell wrote: > > >Without getting into any religious debate here, either straight JDBC or the > >Borland stuff should work about the same. No control needs to be written. > >Both effective open a "dataset" and allow you to walk the structure. What > >you're planning to do is shove the data row by row to the HSSF structure, > >no? My personal preference is plain old JDBC calls. The Borland wrapper > >components are used much more for "bound" interface work. Based on that I > >would think that straight JDBC would be slightly faster, if there is a > >difference. That said, either way should work. > > > >Kind regards, > >Jeff > > > >-----Original Message----- > >From: news [mailto:news@;main.gmane.org]On Behalf Of Peter Boivin > >Sent: Wednesday, October 30, 2002 7:43 AM > >To: [EMAIL PROTECTED] > >Subject: Re: Using Borland's QueryDataSet to send to Excel > > > > > >Let me ask you this then. If I don't use the borland approach, what is > your > >preferred way of getting stuff from a database and pushing it to excel? > > > >"Andrew C. Oliver" <[EMAIL PROTECTED]> wrote in message > >news:3DBFECB2.4070104@;apache.org... > > > > > >>You'd have to write an appropriate control I'd assume. > >>Though, Its been years since I messed with Borland's weird > >>data control stuff...I hope for your sake its better now ;-) > >> > >>-andy > >> > >>Peter Boivin wrote: > >> > >> > >> > >>>If any of you are familar with queryDataSet by Borland (using JBuilder > >>> > >>> > >7), > > > > > >>>could you give me some kind of clue as how to push that over to excel > >>> > >>> > >using > > > > > >>>Poi? > >>> > >>>I have an object of queryDataSet all set. I just don't know how to push > >>>over to excel. > >>> > >>>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> > > > -- > To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- 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>
