Excell Exporter Enhancement - Mailing list pgadmin-hackers

From David Horwitz
Subject Excell Exporter Enhancement
Date
Msg-id 3C836617.B783EEF@ched.uct.ac.za
Whole thread Raw
List pgadmin-hackers
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

Regards

David Horwitz


--
****************************************************
David Horwitz                   University of Cape Town
IT Officer                      Private Bag
Multimedia Education Group      Rondebosch
            7701
dhorwitz@ched.uct.ac.za          SOUTH AFRICA
Tel:+27 21 650 3841              Fax:+27 21 650 5045
http://www.meg.uct.ac.za
PGP key: http://www.meg.uct.ac.za/dhorwitz/david_horwitz.acs
*************************************************


Attachment

pgadmin-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: [ODBC] Multibyte ODBC
Next
From: Dave Page
Date:
Subject: Re: Excell Exporter Enhancement