Re: export to excel

From: Thomas Haneder <Thomas_Haneder_at_web.de>
Date: 9 Feb 2004 02:29:48 -0800
Message-ID: <83254b75.0402090229.29297dbb@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<8fu6209r5vorr1k4e0v66r9bng67lr0rta_at_4ax.com>...
> 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?

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 Received on Mon Feb 09 2004 - 04:29:48 CST