Re: How do I send data made in reports to excel?

To expand on the other threads.

You can either create a tabular layout and specify 'csv' in the parameter form output if you are using Reports 6 or above. See help/oracle metalink documentation for details

Or

Create your query similar to the following

SELECT '"'|| emp.empno ||'","'|| emp.ename ||'","'|| emp.salgrade ||'"' CSV
FROM emp;

This formats your query in CSV format.
Create a basic layout with the one long field. Character mode layout.
Get rid of any margins.
DESFORMAT = WIDE (or any other very wide printer definition) Send output to file.

You can now import the file into excel as a CSV file.

HTH M

"Brian Duff" <bduff_at_uk.oracle.com.DELETE_THIS_BIT> wrote:
>As you say, the easiest way is probably going to involve
 generating to a
>text file first. The most common way to do this for
 spreadsheets is to use
>..csv (comma separated value) format. Export an XLS file as CSV
 from Excel to
>see an example of this.
>
>Brian
>
>Corto Maltese <corto_at_castel.nl> wrote in message
>news:8iqjqi$7i4$1_at_nnrp1.deja.com...
>>
>>
>> Hi all,
>>
>> Is there any way to get the data retrieved with Reports 2.5
 send or put
>> (semi)automatically to Excel??
>>
>> It can always be done sending the output to file, but doing
 this it
>> must be parsed to column, formatted etc., there may be a
 easier way...
>>
>> Thanks on ferehand,
>>
>> CM.
>>
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
>
>
>

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jun 27 2000 - 00:00:00 CEST