Re: Excell Exporter Enhancement

> -----Original Message-----
> From: David Horwitz [mailto:Dhorwitz(at)ched(dot)uct(dot)ac(dot)za]
> Sent: 04 March 2002 12:19
> To: pgadmin-hackers(at)postgresql(dot)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.