Path: news.easynews.com!easynews!ps01-sjc1!news.webusenet.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news2.calgary.shaw.ca.POSTED!not-for-mail X-Trace-PostClient-IP: 24.83.2.213 Message-ID: <3D28B3BB.4050901@home.com> From: mark tompkins User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3 X-Accept-Language: en-us MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Start MS-excel from oracle on clientPC References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 42 Date: Sun, 07 Jul 2002 21:32:13 GMT NNTP-Posting-Host: 24.69.255.206 X-Complaints-To: abuse@shaw.ca X-Trace: news2.calgary.shaw.ca 1026077533 24.69.255.206 (Sun, 07 Jul 2002 15:32:13 MDT) NNTP-Posting-Date: Sun, 07 Jul 2002 15:32:13 MDT Organization: Shaw Residential Internet Xref: easynews comp.databases.oracle.server:153326 X-Received-Date: Sun, 07 Jul 2002 14:29:33 MST (news.easynews.com) 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. > > >