Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to wrap text automatically while export data from oracle to excel?

668816Nov 12 2009 — edited Nov 13 2009
Hello,

I am exporting data from oracle to excel.
My code is written in psp. i have written following code to export xls file
<%
owa_util.mime_header('application/vnd.ms-excel',FALSE);
htp.p('Content-Disposition: attachment; filename="excel.xls"');
owa_Util.Http_Header_Close;
%>

Now in xls file i want to wrap the text automatically while export the data.
Can you plz tell me what to do?

Thanks...

Comments

EdStevens

Look at CREATE USER IDENTIFIED GLOBALLY ..
I'v never done it myself, but saw a colleague demonstrate it once at a conference. I believe you have to install Oracle Internet Directory (OID), and you can then sync that with LDAP. Sorry I can't provide more details, but at least I can confirm that it is possible. Perhaps someone else will weigh in with more details.
This should help you get started: https://docs.oracle.com/en/middleware/idm/internet-directory/12.2.1.3/index.html

Emad Al-Mousa

Hi,
there is a feature called CMU: https://docs.oracle.com/en/database/oracle/oracle-database/18/dbseg/integrating_mads_with_oracle_database.html#GUID-9739D541-FA9D-422A-95CA-799A4C6F488D

Regards,
Emad

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 11 2009
Added on Nov 12 2009
#excel, #xml
9 comments
1,608 views