OraFAQ Forum: Reports & Discoverer » Report in Export in Excel Format

Home » Developer & Programmer » Reports & Discoverer » Report in Export in Excel Format (Report 6i, Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report in Export in Excel Format [message #662657]

Tue, 09 May 2017 01:03

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Can we Export the Report 6i in Excel Format(.XLS)?
thanks

Report message to a moderator

Re: Report in Export in Excel Format [message #662662 is a reply to message #662657]

Tue, 09 May 2017 06:26

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Not directly. However, if you specify report parameter DESFORMAT=DELIMITED, Excel will be able to read it.

Report message to a moderator

Re: Report in Export in Excel Format [message #662664 is a reply to message #662662]

Tue, 09 May 2017 06:30

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Thanks for Reply Little Foot,
Read means then we can open the File in Excel, in whatever the format defined in the Report?

Report message to a moderator

Re: Report in Export in Excel Format [message #662665 is a reply to message #662664]

Tue, 09 May 2017 06:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Think!

I'll send you a PDF file; will you be able to open it with Excel?

Report message to a moderator

Re: Report in Export in Excel Format [message #662669 is a reply to message #662665]

Tue, 09 May 2017 07:32

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Sure it will not open in Excel, what i am requesting, as we can extract in XML, if we setup DESFORMAT=DELIMITED, will we be able to Extract data in Excel as CSV?
Thanks

Report message to a moderator

Re: Report in Export in Excel Format [message #662695 is a reply to message #662669]

Tue, 09 May 2017 14:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No, that's not what you asked. You asked "in whatever the format defined in the Report".

As usual, if you tried it, you'd already know the answer. I'd suggest you to do so.

Report message to a moderator

Re: Report in Export in Excel Format [message #662703 is a reply to message #662695]

Wed, 10 May 2017 00:46

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Thanks for reply and patience, Sorry for embarrassment, will follow the same by setting up DESFORMAT=DELIMITED

Report message to a moderator

Re: Report in Export in Excel Format [message #663559 is a reply to message #662703]

Thu, 08 June 2017 03:28

Lubna
Messages: 12
Registered: June 2017

Junior Member

Yes we can export to excel,
Share you report sample to let you know how it works.

Report message to a moderator

Re: Report in Export in Excel Format [message #663560 is a reply to message #663559]

Thu, 08 June 2017 03:36

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear Lubna,
Thanks a lot for Reply,
which type of Report Sample i need to send you?
we can Export in Ms. word and XML format from File Menu, but Excel is not there,

Report message to a moderator

Previous Topic:	Oracle Reports 6i with Oracle DB 11g. Does it work?
Next Topic:	Add text field to existing repeating frame

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 17:51:29 CST 2025