Re: Excell Exporter Enhancement

> -----Original Message-----
> From: David Horwitz [mailto:Dhorwitz@ched.uct.ac.za]
> Sent: 04 March 2002 12:19
> To: pgadmin-hackers@postgresql.org; Andrew Deacon
> Subject: [pgadmin-hackers] Excell Exporter Enhancement
>
>
> Hello All,
>
> Apologies if this has been discussed on the list before, but
> I am a newcomer to this list and could find nothing like this
> in the list archive.
>
> Essentially I would like to submit an enhancement to the
> Excel exporter. At the moment the values exported are
> interpreted (by Excel 2000 at
> least) as text values. This makes using Excel to analyse that
> data difficult.  If the 'if then' statement is replaced by a
> select case statement that:
>
> a) formats the cell for the data type
> b) inserts the data using the cells 'FormulaR1C1' property,
> which seems to lead to more reliable reading of the format by Excel.
>
> Attached is a version of Exporter module with just such a
> structure for handling some of the more common data types
>

Thanks David. I've commited your update to CVS - it will appear in the next
release. I did make a couple of minor tweaks, one of which made it a far bit
quicker on my system (though the Excel.Application is dog slow anyway :-( ).

Regards, Dave.