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: FED2B709E3270E4B903EB0175A49BCB104765F@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
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-2014 The PostgreSQL Global Development Group