From oracle-l-bounce@freelists.org Mon Jan 10 14:18:00 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0AKI0d09023 for ; Mon, 10 Jan 2005 14:18:00 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0AKHxn09009 for ; Mon, 10 Jan 2005 14:17:59 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EE00A72C5BD; Mon, 10 Jan 2005 15:24:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08921-68; Mon, 10 Jan 2005 15:24:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 503E272CBB6; Mon, 10 Jan 2005 15:21:29 -0500 (EST) Message-ID: From: "Mercadante, Thomas F" To: "'smishra_97@yahoo.com'" , oracle-l@freelists.org Subject: RE: Oracle Data Report to Excel Spreadsheet Date: Mon, 10 Jan 2005 15:16:34 -0500 MIME-Version: 1.0 Content-type: text/plain X-OriginalArrivalTime: 10 Jan 2005 20:16:36.0247 (UTC) FILETIME=[49019A70:01C4F751] Content-Transfer-Encoding: 8bit X-archive-position: 14570 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Sanjay, A very simple way of doing this is to create a tab delimited report (chr(9) between each column) and spool a .xls data file within SqlPlus. This creates and excel-like file that can be opened directly by Excel. I do this all the time and it works fine. It's not fancy, but it always works. Good Luck. Tom -----Original Message----- From: Sanjay Mishra [mailto:smishra_97@yahoo.com] Sent: Monday, January 10, 2005 2:48 PM To: oracle-l@freelists.org Subject: Oracle Data Report to Excel Spreadsheet I had Oracle 9i database and need to convert several reports to Excel Spreadsheet. Is there any procedure that can help. I am planning to use Orace 9iAS Mod Plsql to provide direct report to Excel Spread sheet by call Excel and spreading the data in Columns. I had seen such kind of report Long time back and so any idea, URL or example is of great help to me TIA Sanjay __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l