Re: export to excel

On 6 Feb 2004 00:42:56 -0800, Thomas_Haneder_at_web.de (Thomas Haneder) wrote:

>hello ng,
>i have a problem exporting a database to excel.
>
>here is a excerpt of my code:
>
>tmp := '''' || tmp1;
>htp.tableData(tmp, NULL, NULL ,NULL ,NULL ,NULL
>,'STYLE="vnd.ms-excel.numberformat:@"');
>
>the output of this should be:
><td style="vnd.ms-excel.numberformat:@">'tmp</td>
>
>am i right?
>
>the apostroph before the variable tmp should force excel to interpret
>the value as text, but excel doesn't do that.
>
>could you tell me any links, excel-html-plsql working together(I am an
>absolutly newbie with plsql).
>
>thank you

Exporting to csv instead of the native xls format would be sufficient, and I think you are wasting your time.
Excel can read csv files.
As you, as many, many, many, many other people (especially from Germany) are very scarce about details like version numbers etc and the answer is version-dependent, your 'excel-html-plsql' tag indicates you are up to something else.
So what are you exactly up to that you think you need to reinvent the wheel?

--
Sybrand Bakker, Senior Oracle DBA