oracle database into excel format

Thread view:

mangyan - 26 Oct 2005 21:51 GMT

HI,

I'm trying to build an application that would connect to an Oracle
database and would display that in Excel format without using the
browser. Is there any Excel plugin (open source)available that I can
use?

Thanks,
mangyan

Reply to this Message

Dave Glasser - 27 Oct 2005 03:36 GMT

"mangyan" <mendraz@gmail.com> wrote on 26 Oct 2005 13:51:59 -0700 in
comp.lang.java.programmer:

>HI,
>
>I'm trying to build an application that would connect to an Oracle
>database and would display that in Excel format without using the
>browser. Is there any Excel plugin (open source)available that I can
>use?

Have you considered using Excel itself to connect to the Oracle
database using ODBC?

Data Menu -> Get Ezternal Data -> New Database Query

Signature

Check out QueryForm, a free, open source, Java/Swing-based
front end for relational databases.

http://qform.sourceforge.net

If you're a musician, check out RPitch Relative Pitch
Ear Training Software.

http://rpitch.sourceforge.net

Reply to this Message

mangyan - 27 Oct 2005 15:24 GMT

No, because what we intend to do is there will be a log-on screen first
then if the user is a valid one, he can choose which table he wanted to
view and edit. After choosing which table it is, the content of the
table will be shown in a excel format where he can add or update the
records.

> "mangyan" <mendraz@gmail.com> wrote on 26 Oct 2005 13:51:59 -0700 in
> comp.lang.java.programmer:
[quoted text clipped - 21 lines]
>
> http://rpitch.sourceforge.net

Reply to this Message

Dave Glasser - 27 Oct 2005 15:42 GMT

"mangyan" <mendraz@gmail.com> wrote on 27 Oct 2005 07:24:27 -0700 in
comp.lang.java.programmer:

>No, because what we intend to do is there will be a log-on screen first
>then if the user is a valid one, he can choose which table he wanted to
>view and edit. After choosing which table it is, the content of the
>table will be shown in a excel format where he can add or update the
>records.

Are you committed to using Excel as an actual part of the app, or do
you just want an Excel-like display of the data? If the latter, then I
would recommend that you just use a JTable to display and edit the
data. My app QueryForm (http://qform.sourceforge.net) displays a
resultset in a JTable, although you can't update it. The source code
would give you an idea of how to approach it, however.

Signature

Reply to this Message

mangyan - 28 Oct 2005 14:55 GMT

Hi Dave,

Thanks for the reply. If we could find one the better and it doesnt
need to be in java.

> "mangyan" <mendraz@gmail.com> wrote on 27 Oct 2005 07:24:27 -0700 in
> comp.lang.java.programmer:
[quoted text clipped - 22 lines]
>
> http://rpitch.sourceforge.net

Reply to this Message

Benji - 27 Oct 2005 03:44 GMT

> I'm trying to build an application that would connect to an Oracle
> database and would display that in Excel format without using the
> browser. Is there any Excel plugin (open source)available that I can
> use?

To expound on what the previous poster said, I'd be willing to bet that
you could automate it using VBA, or (for an external solution) something
that can use COM. Microsoft was fairly good about giving a com interface
to just about all of the functionality in office products.

Signature

Of making better designs there is no end,
and much refactoring wearies the body.

Reply to this Message

Malte - 27 Oct 2005 14:58 GMT

> HI,
>
[quoted text clipped - 5 lines]
> Thanks,
> mangyan

You could consider exporting csv from Oracle, then import into Excel.

Reply to this Message

Sridhar Sathya - 29 Dec 2005 11:18 GMT

> HI,
>
[quoted text clipped - 5 lines]
> Thanks,
> mangyan

I do something like this; however I use Sybase. I extract the data and
within my application I use "jexcelapi",
http://www.andykhan.com/jexcelapi/, to create and populate excel s/s.

Reply to this Message

jason - 29 Dec 2005 13:20 GMT

I've created excel docs on several occasions in java. The best API I
have found for doing this is Apache Jakarta POI at
http://jakarta.apache.org/poi.

Reply to this Message

Richard Wheeldon - 04 Jan 2006 21:16 GMT

Just return an Excel file as the result and it should appear correctly
in IE at least - assuming Office is installed. If you want to return an
Excel sheet take a look here:
http://www.andykhan.com/jexcelapi/
or here:
http://jakarta.apache.org/poi/index.html

Richard

Reply to this Message

oracle database into excel format

Free Magazines