Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Start MS-excel from oracle on clientPC
The apache project has sub-project called POI, which is a java library
for accessing excel files. I've only tested this library briefly, so I
can't really comment on its maturity. However, they do makes taunts at
Formula1, the only other contender that I was aware of, so it might be
worth a look.
Gives access/control over excel spreadsheets from java.
Does that solve your problem?
Siebe Jongebloed wrote:
>Hi there,
>
>I would like to combine functionality of Oracle and Excel.
>
>The idea is to use Oracle-Table-records-columns inside excel-spreadsheet to
>calculate new values of other Oracle-Table-records-columns. The spreadsheet
>itself should also reside inside a Oracle-'BLOB' with information on which
>Oracle-source-records are used inside the excel-spreadsheet.
>
>A trigger inside Oracle should cause
>
> 1.. a particularly spreadsheet be sent to a oracle-client machine,
> 2.. start excel,
> 3.. update target values,
> 4.. as soon as source-records have changed.
> 5..
>How is this possible?
>
>
>
>Thanks in advance.
>
>
>
>Siebe.
>
>
>
Received on Sun Jul 07 2002 - 16:32:13 CDT