Re: JAVA to EXCEL

Article View: borland.public.jbuilder.java.language

Article #15352

Back to borland.public.jbuilder.java.language Previous Next

#15352

From: Adrian Faur
Date: Sun, 20 Jun 1999 00:00

22 lines
2053 bytes

Hi!

Use Jdbc and the Odbc driver for Excel. Have Odbc driver for Excell installed.
Use JdbcOdbc bridge from Sun as the Jdbc implementation.
Name your cells that you want to accesss (give a name to the data area you want
to access). The rest is pure Jdbc, get a result set... (of course columns are
unnamed),
from a table with the same name you named the data area. Naming more areas in
your spreadsheet give you the ability to access those areas as well as
pseudo-tables
in a relational database.

you welcome.

MJR wrote:

> Does anyone know the Java methods for manipulating/accessing the contents of
> an Excel sheet?
>
> Thanks.

Technical Details

Message-ID: <374D2DD2.4C7C24C0@sympatico.ca>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7ke07i$c62$1@mailint03.im.hou.compaq.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111d6b,6b8e5bc40d86b35a
X-Google-Attributes: gid111d6b,public
X-Google-Thread: f5d71,6b8e5bc40d86b35a
X-Google-Attributes: gidf5d71,public
X-Google-Thread: fa45f,6b8e5bc40d86b35a
X-Google-Attributes: gidfa45f,public
X-Google-Thread: 10bb9b,6b8e5bc40d86b35a
X-Google-Attributes: gid10bb9b,public
X-Google-Thread: 113ae9,6b8e5bc40d86b35a
X-Google-Attributes: gid113ae9,public
X-Google-Thread: f74b3,6b8e5bc40d86b35a
X-Google-Attributes: gidf74b3,public
X-Google-Thread: fecd1,6b8e5bc40d86b35a
X-Google-Attributes: gidfecd1,public
X-Google-Thread: 10a146,6b8e5bc40d86b35a
X-Google-Attributes: gid10a146,public
From: Adrian Faur <afaur@sympatico.ca>
Subject: Re: JAVA to EXCEL
Date: 1999/06/20
Message-ID: <374D2DD2.4C7C24C0@sympatico.ca>
X-Deja-AN: 491776819
Content-Transfer-Encoding: 7bit
References: <7ke07i$c62$1@mailint03.im.hou.compaq.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: news21.bellglobal.com 929895110 206.172.139.7 (Sun, 20 Jun 1999 12:11:50 EDT)
Organization: Sympatico
MIME-Version: 1.0
NNTP-Posting-Date: Sun, 20 Jun 1999 12:11:50 EDT
Newsgroups: borland.public.jbuilder.java.language,comp.lang.java,comp.lang.java.api,comp.lang.java.help,comp.lang.java.machine,comp.lang.java.misc,comp.lang.java.programmer,microsoft.public.inetexplorer.ie4.java_applets

Reply to Parent Message