Skip site navigation (1) Skip section navigation (2)

Re: Excell Exporter Enhancement

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Dhorwitz(at)ched(dot)uct(dot)ac(dot)za'" <Dhorwitz(at)ched(dot)uct(dot)ac(dot)za>,pgadmin-hackers(at)postgresql(dot)org,Andrew Deacon <adeacon(at)ched(dot)uct(dot)ac(dot)za>
Subject: Re: Excell Exporter Enhancement
Date: 2002-03-04 13:15:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers

> -----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.

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2002-03-04 17:04:10
Subject: Pseudo alter triggers
Previous:From: David HorwitzDate: 2002-03-04 12:18:32
Subject: Excell Exporter Enhancement

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group