Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-pusher.readnews.com!198.186.190.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "Bart the bear" <bartthebear@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: oracle output to excel
Date: 2 Feb 2006 07:56:49 -0800
Organization: http://groups.google.com
Lines: 15
Message-ID: <1138895809.579801.252920@f14g2000cwb.googlegroups.com>
References: <1138874234.281839.224340@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 65.223.164.123
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1138895815 29326 127.0.0.1 (2 Feb 2006 15:56:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Feb 2006 15:56:55 +0000 (UTC)
In-Reply-To: <1138874234.281839.224340@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=65.223.164.123;
   posting-account=1DGW9Q0AAABbT7ZgsGO18ULDzZz8WL9R
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260567


Murtuja wrote:
> I want daily report in Excel format.and this excel file should be
> mailed to client.I want autoamtic process for that just like cron job.
>
> I am using Oracle 9i on Linux

I believe that a good combination of DBI, DBD::Oracle and
Spreadsheet::WriteExcel or
Spreadsheet::SimpleExcel is what you are looking for. If you want to
send it all by email,
you can use MIME::Lite. These modules are available from CPAN,
Comprehensive Python
Archive Network.