Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export to excel

Re: export to excel

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 09 Feb 2004 21:06:09 +0100
Message-ID: <c08ojp$fu7$1@news4.tilbu1.nb.home.nl>


Thomas Haneder wrote:

[SNIP!]
>
> Ok, thank you for your answer.
> Sorry that i didnīt mentioned the version numbers.
>
> Recently I solved the problems.
> The question was: How should the code of the html-file (output from
> plsql procedure) look like, that excel interpret the cells as a string
> (I need that, to utilize the Auto-Filter mechanism of excel).
> Recently I solved the problem this way:
> plsql procedure:
>
> htp.p('<html xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns="http://www.w3.org/TR/REC-html40">'); -- that`s important
> htp.p('<table x:str border=1 >');
> LOOP
>
> -- table row data
>
> ENDLOOP
>
> .....
>
> Now I realised that it wasn`t a plsql problem.
> Sorry for that.
>
> Thomas

Thanks for sharing the solution!

-- 

Regards,
Frank van Bortel
Received on Mon Feb 09 2004 - 14:06:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US